Conclusion

Microsoft SQL Server 6.5 replication is implemented using a flexible architecture that gives the SQL Server developer many options for establishing continuous replication of data while ensuring transactional consistency. Understanding this architecture and some common scenarios that rely on replication can aid in the production and implementation of a scalable and robust solution for distribution of your data. Whether your specific business problem requires leveraging multiple servers for improved performance, availability, or local site autonomy, Microsoft SQL Server replication can be a key enabling technology in the development of your distributed applications.

Finding More Information

These resources may be useful when planning and deploying an application employing Microsoft SQL Server Replication.

Microsoft on the World Wide Web

• Microsoft home page: www.microsoft.com/
  
  
• Microsoft SQL Server: www.microsoft.com/sql/
  
  
• Microsoft SQL Server Support: www.microsoft.com/sqlsupport/
  
  
• Microsoft BackOffice: www.microsoft.com/backoffice/
  
  
• Microsoft Windows NT Server: www.microsoft.com/ntserver/
  
  
• Training and Certification: www.microsoft.com/train_cert/

Microsoft Online Technical Resources

• Microsoft TechNet Monthly Subscription
  
  
• Microsoft Developer Network (MSDN) CDs
  
  
• Microsoft Knowledge Base:

  INF: Getting Started with Microsoft SQL Server Replication, Article ID: Q89937

  INF: How to Manually Remove Replication, Article ID: Q170481

  INF: Replication Setup Over a Firewall, Article ID: Q164667

  INF: Replication and SQL Server Versions, Article ID: Q164517

  INF: Replication and Windows NT Server Network Configuration, Article ID: Q160563

Other Publications

• Inside Microsoft SQL Server, Ron Soukup, Microsoft Press (Available Fall 1997)
  
  
• Database Development Guide to MS SQL Server, Thomas O'Grady, SAMS (1996), ISBN: 0-672-30859-2
  
  
• Guide to SQL Server, 2^nd edition,  Aloke Nath, Addison-Wesley (1995), ISBN: 0-201-62631-4
  
  
• Microsoft SQL Server 6.5 DBA Survival Guide, 2^nd edition, Mark Spenik, SAMS (1996), ISBN: 0-672-30959-9
  
  
• Microsoft SQL Server Survival Guide, Jim Panttaja, Wiley (1996), ISBN: 0-471-12743-4