cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CChong
By Level 11 Flexeran
Level 11 Flexeran
Does anyone know if there is an InstallShield product that allows a setup to run a SQL script? Thanks!
(1) Reply
If you're looking for a way to do it directly through the msi, then to launch your SQL script, you'll have to create a custom action to call one of the various sql executables (osql.exe, sql.exe, sqlplus.exe, or Svrmgrl.exe) and pass it your script file as a parameter.

If you're looking for an installscript based solution, then you can find an example of this on installsite.org under the heading "SQL Server Database Maintenance" at the following link:

http://www.installsite.org/pages/en/isp_db.htm

Hope this helps.

Mark D
Software Quality Engineer
InstallShield Software Corp.