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

asked 14 Jan '11, 00:40

Calvin%20Allen's gravatar image

Calvin Allen
1.5k232638
accept rate: 25%


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.

permanent link

answered 21 Jan '11, 15:37

Bill%20Hillis's gravatar image

Bill Hillis
83637
accept rate: 66%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×113
×4
×3
×2
×1

question asked: 14 Jan '11, 00:40

question was seen: 1,567 times

last updated: 21 Jan '11, 15:37