I'm looking for advice or guidance as to whether we can accomplish this with Advanced Installer.
Can the tool be used to build an EXE wrapper installer that extracts files ( .bat & .sql ) to disk and then executes a Batch file among the extracted scripts that runs the necessary SQL scripts?
We formerly used WiseScript Package Editor ( .wse ) files to produce this EXE installation where it performed the following actions:
1. Collected information in a Wizard ( Server Name, Database Name, etc )
2. Extracted the necessary DB installation scripts temporarily to disk ( .bat and .sql files )
3. Executed the Batch file within these script that controls applies the updates via SQL scripts
4. Removes the scripts from disk
Although we plan to use Advanced Installer for our application installation, the database component is a different animal where we don't necessarily want to involve "Windows Installer" technology and would like to model the solution after our approach we had with WiseScript.
Any advice would be appreciated.
FOLLOW US
Get the latest news in Application Packaging