Export (0) Print
Expand All

Advanced Copy Options

SQL Server 2000

Advanced Copy Options

Use this dialog box to specify which objects to copy from one instance of Microsoft® SQL Server™ to another.

Options

Copy database users and database roles

Copy all database users and roles.

Copy SQL Server logins (Windows NT and SQL Server logins)

Copy all SQL Server logins.

Copy object-level permissions

Copy all object-level permissions.

Copy indexes

Copy indexes for all tables copied, if applicable.

Transfer triggers

Copy triggers for all tables copied, if applicable.

Copy full text indexes

Copy full-text indexes for all tables copied, if applicable.

Copy PRIMARY and FOREIGN keys

Copy primary and foreign key definitions for all tables copied.

Generate Scripts in Unicode

Copy data as Unicode. Useful if source data contains nchar data types or double-byte character set (DBCS) data. For more information about Unicode, see Unicode Data.

Use quoted identifiers when copying objects

Enclose all object names in quotation marks.

See Also

Copy SQL Server Objects Task

Show:
© 2014 Microsoft