SQL Scripts View

InstallShield 2015

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

Basic MSI
DIM
InstallScript
InstallScript MSI

The SQL Scripts view provides a central location for managing and organizing all SQL scripts by server connections and settings. This view provides support for Microsoft SQL Server, Microsoft Windows Azure, MySQL, and Oracle. You can perform most of the following major functions to configure your SQL servers from the SQL Scripts view. Some limitations apply to certain server types.

Connect to SQL servers.
Import catalog schema and/or data.
Associate SQL scripts with features.
Set required SQL server/script properties (server name, database name, authentication method, etc.).
Set SQL script for execution during installation or uninstallation.
Edit SQL scripts.
Require and/or target specific versions of Windows Azure SQL, SQL Server, MySQL, or Oracle.
Define SQL script text replacement.
Open scripts in Microsoft SQL Server Management Studio or Microsoft SQL Server Query Analyzer.

Note: The import database functionality applies to the Microsoft SQL Server Database. Oracle users should refer to the Oracle Web page on Oracle Database Utilities for information on utilities that may work in conjunction with InstallShield.

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)

SQL Connections

In the SQL Scripts view, scripts are organized by connection, since no script can run on a server until a connection has been established. Furthermore, the grouping of connections with corresponding scripts facilitates the sharing of connection settings to different scripts.

When you create or select a SQL connection in the SQL Scripts view, the following tabs are available:

General tab
Requirements tab
Advanced tab

See Also