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

Controlling SQL Scripts execution sequence

Hi
I have a Basic MSI Project, with several SQL Scripts Script1.SQL, Script2.SQL, Script3.SQL etc. These all run fine.

I need Script1.SQL to execute when the user clicks on the 'Next' button in the standard 'SQLLogin' dialog, and not when Installshield schedules it in a standard way
How can this be done? Somebody help.


Also, can someone explain at what point of time in the Installation sequence the SQL Scripts are actually executed ? Is there a way to control the execution of SQL Scripts to make it happen a little earlier/later than what Installshield normally does? if so, how

Thanks
Labels (1)
0 Kudos
(2) Replies
hidenori
Level 17

You need to mark the Run Script During Login checkbox in the Runtime tab if you want to run a SQL script when the Next button on the SQLLogin dialog is clicked.

SQL scripts that are scheduled to run during installation are executed by the ISSQLServerInstall action. Moving the sequence of the built-in action is not recommended unless you are really sure what you are doing.
0 Kudos
abby27
Level 4

Thank you, that really helps !:)
0 Kudos