Chapter 22. Data Replication


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



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net