CHAPTER 15Transferring Data
In this chapter, you will learn about:
• Replication
• SQL Server Integration Services (SSIS)
• Bulk Imports and Exports, including bcp
|
The pessimist sees the difficulty in every opportunity; the optimist, the opportunity in every difficulty —L.P. Jacks |
Many times, we're tasked with getting data from here to there—from one database to another database, or from one server to another server. For the simplest tasks, we have our old friend bcp—the command-line bulk copy program that's been in SQL Server since before SQL Server 7.0.
For more complex tasks, we have SQL Server Integration Services (SSIS), which replaces Data Transformation Services (DTS) from SQL Server 2000. SSIS can be used for extract, transform, and ...
Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
