Advanced Scripting Options Panel

InstallShield 2016 » Database Import Wizard

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

The Advanced Scripting Options panel lets you specify security scripting options, as well as the file format.

Security Scripting Options

Security Scripting Options
Setting	Description
Script database	Generate a Transact-SQL statement to create a script of the existing database schema.
Script database users and database roles	Generate a Transact-SQL statement to create all users and roles that have access to the database.
Script SQL Server logins (Windows NT and SQL Server logins)	Generate a Transact-SQL statement to create all logins that currently have access to the server.
Script object-level permissions	Generate a Transact-SQL statement to create all grant, revoke, and deny permissions that currently exist for each object selected on the Objects to Script panel.

File Format

File Format Options
Option	Description
Windows Text (ANSI)	This is the default option. If you want the script to be in ANSI format, select this option.
International Text (Unicode)	International databases can use the Unicode file format for the script, if necessary. If you select this option, Unicode BOM encoding for your SQL script.

Note • Consult your SQL-DMO help reference for more detailed information about script formatting and file formats.

InstallShield 2016 Help Library