O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required