Chapter 6 -- Transferring Data

[Previous] [Next]

Chapter 6

About This Chapter

In this chapter, you will learn how to transfer data and database objects into and out of Microsoft SQL Server databases. SQL Server provides a number of data transfer mechanisms. The bulk of the chapter focuses on one of these Data Transformation Services (DTS). The others are briefly introduced, with more detail provided in Books Online, which can be found in the SQL Server 7 program group.

Before You Begin

To complete the lessons in this chapter, you must have

• Installed SQL Server 7. See Chapter 2, "Installation," for installation instructions.
• The ability to log on to SQL Server as an administrator.
• Installed the StudyNwind database. See Chapter 2, "Installation," for installation instructions.
• Installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive.