SQL Script Level

InstallShield 2024 » SQL Scripts View » SQL Connection » SQL Script

Project: The SQL Scripts view is available in the following project types:

Basic MSI
DIM
InstallScript
InstallScript MSI

When you click a SQL script in the SQL Scripts view, the following tabs are available:

General tab
Script tab
Runtime tab
Database Import tab
Text Replacement tab

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 your system for the following tools in order and launches the first one that it finds:

1. Microsoft SQL Server 2008 Management Studio (any edition, including Express; ssms.exe)
2. Microsoft SQL Server 2005 Management Studio (SqlWb.exe)
3. Microsoft SQL Server 2005 Management Studio Express (ssmsee.exe)
4. Microsoft SQL Server 2000 Query Analyzer (isqlw.exe)

See Also