4. Select the Source Tables and Views. Depending on what kind of source
you selected, there may be multiple tables or views in the source that you
can import from. The wizard will allow you to select one or more of the
specific tables and views. Or if the data source is support queries, you
could instead write a query to extract just the data you want from the
source.
Once you have selected the source objects you can map them to
destination objects. If the destination tables already exist, you can select
them, or you can define new tables for the data to be loaded into.
The wizard will help to generate the SQL statement to create the target
table. You can also select options regarding whether existing data in the
destination table should be kept or cleared, how values for identity
columns should be handled, and so on.
Bạn đang xem 4. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P77 PPSX