Chapter 7 -- Replication

Chapter 7

About This Chapter

In this chapter, you will learn about the concepts and terminology associated with replication and distributed data. Like Data Transformation Services (DTS) and other methods for transferring data, replication has many uses. Data warehouses can benefit from using replication to migrate and archive data between data warehouses and data marts. The chapter concludes with some examples of how you might use replication in a data warehouse environment.

Before You Begin

To complete the lessons in this chapter, you must

• Have installed SQL Server 7.0
• Be able to log in to SQL Server as an administrator