Microsoft SQL Server 2008 R2 Unleashed- P61:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | This page intentionally left blank Download from CHAPTER 19 Replication There is no such thing as a typical configuration or application 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 wide area network wireless connections and dialup connections 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 technical capabilities of data replication. Data replication is a set of technologies for storing and forwarding data and database objects from one database to another and then synchronizing this data between databases to maintain consistency. With SQL Server 2008 the data replication feature set offers numerous improvements in manageability availability programmability mobility scalability and performance. This chapter does the following Helps you understand what data replication is Shows you how to understand and analyze user requirements of data Allows you to choose which replication configuration best meets these requirements if any IN THIS CHAPTER What s New in Data Replication What Is Replication The Publisher Distributor and Subscriber Magazine Metaphor Replication Scenarios Subscriptions Replication Agents Planning for SQL Server Data Replication SQL Server Replication Types Basing the Replication Design on User Requirements Setting Up Replication Scripting Replication Monitoring Replication Download from 546 CHAPTER 19 .
