by Paul Bertucci
IN THIS CHAPTER
What Is Replication?
The Publisher, Distributor, and Subscriber Metaphor
Replication Scenarios
Replication Agents
Planning for SQL Server Data Replication
SQL Server Replication Types
User Requirements Drive the Replication Design
Setting Up Replication
Scripting Replication
Monitoring Replication
Nothing is typical anymore. Companies now have to support numerous hardware and software configurations in multitiered, distributed environments. These diverse configurations and applications (and users of the applications) come in all sizes and shapes. And, of course, you need a way to deal with varied data access requirements for these different physical locations, these remote or mobile users over a local area network, any dial-up connection users, and any needs over the Internet. Microsoft's Data Replication facility allows for a great breadth of capability to deal with many of these demands. However, to build a proper data replication implementation that meets many of these user requirements, you must have a thorough understanding of the business requirements and of the technical capabilities of data replication. This chapter does the following:
Aides you in understanding what data replication is
Shows you how to look at the users' requirements of data
Allows you to choose which replication configuration best meets these requirements (if any)
Demonstrates how to implement this configuration
Describes how to administer and monitor a data replication implementation