Migrating Microsoft SQL Server Objects

Go Up to Migration and Object Restrictions/requirements

The table describes the condition(s) that need to be satisfied on the target database to migrate objects:

Object	Condition(s) on Target Database
Aliases	The login must already exist on the target server. The user must already exist in the target database.
Defaults	The owner of the default must exist in the target database. Any bound user datatypes must exist in the target database. Any bound table columns must exist in the target database.
Groups	To migrate any object privileges granted to groups, the database objects must already exist in the target database.
Linked Servers	Links do not migrate. So, after you migrate a linked server, open the Linked Server Editor and create new linked server logins. For more information, see Linked Servers Editor (SQL Server).
Procedures	The user who owns the procedure(s) must already exist in the target database. Any objects referenced by the procedure(s) must already exist in the target database.
Remote Servers	DBArtisan lets you migrate the schema for one or more remote servers between cross-platform DBMSs. Specifically, you can migrate remote servers between different versions of Microsoft SQL Servers and Sybase ASE. To migrate remote servers, DBArtisan establishes separate connections to both the source and target servers and copies the DDL between the source and target databases.
Roles	To migrate any object privileges granted to roles, the database objects must already exist in the target database.
Rules	The owner of the rule must exist in the target database. Any bound user datatypes must exist in the target database. Any bound table columns must exist in the target database.
Segments	To migrate segments successfully, all referenced database fragments must already exist in the target database.
Tables	Any referenced user datatypes must already exist in the target database. If you are copying segment placement also, then the segments must already exist in the target database. Any defaults referenced by the table must already exist in the target database. Any rules referenced by the table must already exist in the target database. If the tables have foreign key references to tables not included in the migration, these tables must already exist in the target database.
Triggers	The base tables and their owners must already exist in the target database. Any objects referenced by the trigger, including other tables, views and other stored procedures, must already exist in the target database.
User Datatypes	The owner of the user datatype must exist in the target database. Any bound defaults and rules must exist in the target database.
Users	The logins must already exist in the target server. The database objects must already exist in the target database.
Views	Any objects referenced by the view, including tables and other views, must already exist in the target database. The owner of the view must already exist in the target database.