i would like to be able to have a file specifying what sql files get executed in which order. i can code all that without using the IA apis but that seems to defeat the purpose of having the tool! i've used the database 'hosts' to execute sql files and that works nicely, but only for hard coded sql file names and we'd like the ability to easily edit the file list to execute without having to rebuild the installer.
The custom code action connects to a database, reads SQL from a file, executes the queries, and closes the database.
So all you need to do is to call the the plugin for the different .SQL files you need to run. However, I don't think you can ever find a solution that would let you change the execution order within the installer... unless you write custom code.
thanks Vlad. i guess i need to customize that custom code to get the external file containing the list of files, and then do the sql file execs.
i've also got to make it work with 2 types of db's and thus have to build the 'URL' for the connection, etc. sigh... the run sql script standard action for each db host seems a lot easier.
