Configuring SQL Support

InstallShield 2020

Project:This information applies to the following project types:

Basic MSI
InstallScript MSI

Note:For information about configuring SQL support in Suite/Advanced UI projects, refer to Adding a SQLLogin Predefined Wizard Page in a Suite/Advanced UI Project.

InstallShield provides SQL support for Microsoft SQL Server, Microsoft Windows Azure, MySQL, and Oracle. The SQL Scripts view provides a central location for managing and organizing all SQL scripts by server connections and settings within the user interface. SQL support within InstallShield enables you to do the following:

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 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)

See Also