This course explains how to move large amounts of data either within a single server or between servers. Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) are also discussed.
Objectives:
Explain importing and exporting data with SQL Server 2005
Import and export data using the Bulk Copy Program (BCP)
Use OPENROWSET to access any OLE DB data source
Use SSIS to handle the import and export of data
Implement Service Broker
Assemble components into a service
Topics:
Importing and Exporting Data
Using the Bulk Copy Program
Using OPENROWSET and SSIS
Implementing Service Broker
Assembling Components into a Service
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
