The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Sql Scripts

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

MarkJD
By
Level 5
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.