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.