826
Part V: Enterprise Data Management
FIGURE 31-18
Viewing the Migrated Data.This section isn’t intended to be an SSIS primer. Great books about SSIS that focus on beginner topics all the way to
advanced topics are available. Brian Knight is a SQL Server MVP who has written numerous books on SSIS; his books
are highly recommended if you’re looking for SSIS information and instruction.So far, this chapter has covered SSIS and the SQL Server Generate and Publish Scripts
Wizard, which both offer viable but different options for migrating your data. For example,
SSIS doesn't migrate schema while the Scripts Wizard does. The third tool, bcp, also pro-
vides a method for migrating data to SQL Database.Using bcp Utility
The bcp utility provides bulk copying of data between instances of Microsoft SQL Server.
This utility is installed with SQL Server and requires no knowledge or understanding of
T-SQL syntax. If you aren’t familiar with the bcp utility, don’t confuse or associate its
functionality with that of the Import/Export Wizard in SQL Server. Although the bcp docu-
mentation refers to what bcp does as a “bulk copy,” be aware that you can’t bcp data from
a source into a destination with a single statement. You must fi rst bcp the data out of the
source; then, you can bcp the data into the destination.c31.indd 826c31.indd 826 7/31/2012 10:00:30 AM7/31/2012 10:00:30 AM
http://www.it-ebooks.info