Database Reference
In-Depth Information
4.
Select the right target database, and click Next.
The Specify Table or Query screen opens, as shown in Figure 8-21. You have two options. You
can copy data from other tables or views, or you can write your own query to specify the
dataset to transfer over. Use the latter when you want to copy a few columns that are spread
over multiple tables in the source system.
Figure 8-21:
Specify Table Copy or Query.
5.
Select the Copy Data from One or More Tables or Views option and click Next.
The Select Source Tables Views screen opens, with a list of tables and views that exist in your
source database (see Figure 8-22).
6.
Select one or more of those objects and click Next.
7.
Choose whether to run the data transfer immediately or save the transfer steps as a package
that can be run on demand. Click Next.
Search WWH ::
Custom Search