This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Controlling SQL Scripts execution sequence
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
‎Sep 08, 2009
12:23 PM
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
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
(2) Replies
‎Sep 09, 2009
10:36 AM
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.
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.