[Incident]: Some users report they are unable to access the case portal. Please see this community notice for more information.

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

SQLRTComponentInstall - InstallScriptMSI Equivalent

Hello, I am looking for an equivalent function to SQLRTComponentInstall in an InstallScriptMSI project. I want to manually execute some SQL scripts upon the end-user clicking on the Next button in the SQLServerSelectLoginDlg2 dialog box.

Any help would be appreciated!
Tim 😉
Labels (1)
0 Kudos
3 Replies
hidenori
Level 17

InstallScript MSI projects do not support an equivalent function of SQLRTComponentInstall because this type of project uses the custom actions to execute SQL scripts. In order to run your SQL scripts based on the end user's input, you need to use the Condition setting of SQL scripts.

Hope that helps.
0 Kudos
TimStVCS
Level 7

Thanks! I don't want to wait until the custom actions fire to run these SQL scripts. I want them to run unconditionally upon clicking the Next button on the SQLServerLoginDlg2 dialog box. Do you know of a way I can do this?

Thanks.

Tim
0 Kudos
hidenori
Level 17

You need to select the "Run Script During Login" checkbox in the Runtime tab. Note that there are some limitations associated with the option. Please see the SQL Scripts View » SQL Connection » SQL Script » Runtime tab help topic for more details.
0 Kudos