Stay informed about any major changes. Click here to subscribe
Specifying source tables and views
Use this dialog box to specify the tables and view to be copied to the
destination.
Source
Shows the tables and views that are available for copying to the destination.
If you select a source and perform no other action, you will copy the
schema and data from the source without changes.
Destination
Sets the destination tables. The wizard automatically matches source
and destination tables or views if it can detect the objects with the
same name in the destination database. If it does not find the match,
it encloses the name of the source object in between brackets ([]) to
indicate that the new table should be created in the destination database.
You can edit the name of the destination table by clicking on its name.
Transform
Displays the Column
mappings and destination table options dialog box, where you specify
which destination columns are to receive source data, edit their data
type, and specify the options for creating the destination table.
