• Article

Select Source Tables and Views (SQL Server Import and Export Wizard)

Use the Select Source Tables and Views page to specify the tables and views to be copied from the data source to the destination.

Note

You do not have to copy all the columns in a table when you select the Table Copy option. After selecting a destination table, click Edit Mappings to display the Column Mappings dialog box. Select <ignore> in the Destination column of the Column Mappings dialog box for columns that you want to skip.

To learn more about this wizard, see Importing and Exporting Data by Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, and about the permissions required to run the wizard successfully, see How to: Run the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Options

Tables and views List

  • Source
    Using the check boxes, select from the list of available tables and views to copy to the destination. If you select a source table or view and perform no other action, the schema and data from the source are copied without changes.

  • Destination
    Select a destination table from the list for each source table.

    Note

    If you pause at this point in the wizard to create a destination table in SQL Server by using Management Studio or another tool, the new table is not immediately visible in the list of available destination tables. To refresh the list of destination tables, step back two pages to the Choose a Destination page, re-select the destination database, then step forward again to the Select Source Tables and Views.

Other Options

  • Edit mappings
    Use the Column Mappings dialog box to specify destination columns to receive the source data. You can copy only a subset of columns by selecting <ignore> in the Destination column of the Column Mappings dialog box for columns that you want to skip.

  • Preview
    Preview source data in the Preview Data dialog box to verify it before performing the import or export. The Preview Data dialog box displays up to 200 rows of data.

    After previewing the data, you might want to change the options that you have selected for the data source and destination. To make these changes, on the Select Source Tables and Views page, click Back to return to previous pages where you can change your selections.