Select Objects

DTS Import/Export Wizard Help

DTS Import/Export Wizard Help

Select Objects

Use this dialog box to specify the objects that you want to transfer to the new database.

Note  If you select one of the options below, you do not mark automatically the objects to be transferred. Instead, you cause the objects to appear in the Objects table. From that table, you then select the objects to transfer.

Options

Show all tables

View all tables in the database in the Objects table.

Show all views

Display all views in the database in the Objects table.

Show all stored procedures

Display all stored procedures in the database in the Objects table.

Show all user-defined functions

Display all user-defined functions in the Objects table.

Show all defaults

Display all database defaults in the Objects table.

Show all rules

Display all database rules in the Objects table.

Show user-defined data types

Display all user-defined data types in the database in the Objects table.

Objects table

Select items individually to include them in the transfer or click the following:

Select All
Select all objects in the database as eligible for transfer to the new database.
Check
Select one or more database objects.
Uncheck
Remove one or more database objects from selection.

See Also

Copy SQL Server Objects Task