How do you upgrade a database schema with InstallShield?

Question

I am using InstallShield to install a SQL Server DB, and the applications that use it. Now I need a way to go back and say, ok, v 27 of the database now needs moved to 28. I have the alter scripts, and I know based on a table which version any given DB is. How can I make InstallShield do this?

Answer 1

I used a C# form app to do this that is launched from installshield using LaunchAppAndWait

This app runs alter scripts that are complied in as resources.