Specify Table Copy or Query
Use this dialog box to specify whether you want to do a simple copy of data or a more complex copy of data that requires an SQL statement to gather and select the appropriate rows to copy.
Copy table(s) and view(s) from the source database
Display the Select Source Tables and Views dialog box, where you can copy fields from the selected tables and views in the source to the specified destination(s). The records will not be filtered or ordered.
Use a query to specify the data to transfer
Display the Type SQL Statement dialog box, where you can build SQL statements to retrieve selected rows. Only the rows matching the selection criteria will be available for copying.
Copy objects and data between SQL Server databases
Display the Select Objects to Transfer dialog box, where you can specify both objects and data to copy, if both the data source and destination are Microsoft® SQL Server™ databases. The objects you can transfer include tables, views, stored procedures, defaults, rules, constraints, user-defined data types, logins, users, roles, and indexes. You can transfer objects only between multiple instances of SQL Server version 7.0, from an instance of SQL Server 7.0 to an instance of SQL Server 2000, and between multiple instances of SQL Server 2000.