Installshield MSI & SQL Execution

[Former Member]

Installshield 2009 Professional & SQL Anywhere 10.0.1

We deploy quite a bit of SQL with every release, and we'd like to automate the upgrades a little more by running the sql through our installshield msi projects. I know they support SQL Server and Oracle, but does anybody have any experience running sql scripts against a sql anywhere database via an installshield MSI?

Thanks, Calvin

[Former Member]

The SQL Anywhere install itself in versions 11 and 12 uses MSI. If you run the install on a non-English machine, we have to build the sample databases so that they get created with the correct local code page. On English or other CP1252 systems, we can just copy the pre-built version of the databases.

We use InstallShield ourselves, but do not make use of any builtin support for running SQL scripts. We use a custom action written in C++ stored in a utility dll in the MSI. In our C code, we start the server, and launch dbisql to execute the SQL to create the database, create the schema and load in the data, and then shutdown the server again.