SQL Scripts View
InstallShield 2016
Project • The SQL Scripts view is available in the following project types:
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. |
|
•
|
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:
See Also
Database Import Wizard
Adding a New SQL Connection
Adding a New SQL Script
Using the SQL Run-Time Functions in InstallScript and InstallScript MSI Projects
Requiring a SQL Server-Side Installation for a Windows Installer-Based Project
Requiring a Server-Side Installation for an InstallScript Project
Overriding the Default SQL Run-Time Behavior
Conditionally Launching a SQL Script in an InstallScript Installation
Handling SQL Run-Time Errors
Installing the MySQL ODBC Driver
Open topic with navigation