Adding a New SQL Script

InstallShield 2016

Project • This information applies to the following project types:

Basic MSI
DIM
InstallScript
InstallScript MSI

To add a new SQL script once you have created a new SQL connection:

1. In the View List under Server Configuration, click SQL Scripts.
2. Right-click the new connection and click New Script.

When you add a new script to your project, InstallShield adds a new component for the script. You must associate the script with a feature. If one does not exist, the Create a New Feature dialog box opens when you add the SQL script, prompting you to create a new feature. You can change the script-feature association later by using the Select Features the SQL Script Belongs to area on the General tab in the SQL Scripts view for the SQL script.

Tip • You can also add scripts to your project by importing or inserting them. For more information, see Inserting and Importing SQL Scripts.

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