Editing a SQL Script File
InstallShield 2020
Project:This information applies to the following project types:
Once you have created, inserted, or imported a script file, you can edit it from within InstallShield.
Project:In an InstallScript project, if you are working on a script that had overridden OnFirstUIBefore before upgrading to InstallShield and it is not calling OnSQLServerInitialize, you should add that code to your script file.
To edit a script file in InstallShield:
|
1.
|
In the View List under Server Configuration, click SQL Scripts. |
|
2.
|
In the SQL Scripts explorer, click the script file that you want to edit. |
|
3.
|
Click the Script tab, which displays the contents of your script file. |
|
4.
|
Edit the file as needed. |
If you want to re-create your script each time that you build your project, you can select the Regenerate SQL Script at Build check box on the Database Import tab for the script in the SQL Scripts view. A backup of any existing script file is always saved first.
Note:If you have Microsoft SQL Server Management Studio or Microsoft SQL Server 2000 SQL Query Analyzer installed on your system, you can open a new SQL script that you have added to your project to test, edit, and syntax-check the script. To launch one of those tools and open your script from within InstallShield, right-click the script file in the SQL Scripts view and then click Open Script in Microsoft SQL Server Management Studio. InstallShield searches for one of the following tools and launches the first one that it finds:
|
•
|
Microsoft SQL Server 2008 Management Studio (any edition, including Express; ssms.exe) |
|
•
|
Microsoft SQL Server 2005 Management Studio (SqlWb.exe) |
|
•
|
Microsoft SQL Server 2005 Management Studio Express (ssmsee.exe) |
|
•
|
Microsoft SQL Server 2000 Query Analyzer (isqlw.exe) |
See Also
Working with the Script Editor Pane in Various Views
SQL Scripts View