SQL Scripts View

InstallShield 2008

Project

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

Basic MSI

InstallScript

InstallScript MSI

Web

The SQL Scripts view provides a central location for managing and organizing all SQL scripts by server connections and settings. The current implementation provides support for the latest versions of Microsoft SQL Server, MySQL, and Oracle. You will be able to perform most of the following major functions to configure your SQL servers from the SQL Scripts view. Some limitations may 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 SQL Server, MySQL, or Oracle.

Define SQL script text replacement.

Open scripts in Microsoft SQL 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.

Microsoft SQL Query Analyzer is part of the Microsoft SQL Server installation. This tool can be run only on SQL Server databases.

To run an installation project with SQL support on a Windows 95 or 98 machine, your system will need to support MDAC setup prerequisites.

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