Scripting Options Panel

InstallShield 2015 » Database Import Wizard

Note: The import database functionality applies to the Microsoft SQL Server Database.

The Scripting Options panel in the Database Import Wizard is where you specify whether your script should be compatible with Microsoft SQL Server version 7.0. Other options on this panel let you specify whether descriptive headers, extended properties, and other information should be included in your script. Transact-SQL statements are generated as needed.

General Options

Option

Description

Create Only If Missing

To generate a Transact-SQL statement that creates a component prefixed by a check for existence, select this check box. When the script is executed, a component is created only if a copy of the named component does not exist.

Note: Currently, this option applies only to tables.

Drop First If Exists

To generate a Transact-SQL statement that removes a referenced component, select this check box. The script tests for the existence of the component prior to an attempt to remove the component.

Include Descriptive Headers

To include explanatory header text before each Transact-SQL statement in the script, select this check box.

Include Extended Properties

To include extended stored procedures in the SQL scripts that are created, select this check box.

Only Script 7.0 Compatible

To generate a script that is compatible with Microsoft SQL Server version 7.0, select this check box.

If you select this check box, the following SQL Server 2000 options are ignored:

•

Column level collation

•

User-defined functions

•

Extended property

•

INSTEAD OF trigger on tables and views

•

Indexes on views (indexed views)

•

Indexes on computed columns

•

Reference permissions on views

•

Descending indexes

Table Scripting Options

Table Scripting Options
Setting	Description
Script Indexes	To generate a Transact-SQL statement that creates indexes that currently exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Full-Text Indexes	To generate a Transact-SQL statement that creates full-text indexes, select this check box. Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Triggers	To generate a Transact-SQL statement that creates triggers that exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Check Constraints	To generate a Transact-SQL statement that creates check constraints that exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Foreign Keys	To generate a Transact-SQL statement that creates FOREIGN keys that exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Primary Keys	To generate a Transact-SQL statement that creates PRIMARY keys that exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.
Script Defaults	To generate a Transact-SQL statement that creates defaults that exist for any selected tables, select this check box. Note: Selecting this check box is useful only if one or more tables are selected on the Database Tables panel.

Scripting Options Panel

InstallShield 2015 Help Library

June 2015