Scripting Options Panel

InstallShield 2024 » 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

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. Selecting this check box helps to include the metadata info about objects— created by a user —in the Microsoft SQL Server. For more information, see sp_addextendedproperty (Transact-SQL).

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.