Mate

Replication

Prerequisite: Configuring your Server for Replication

Module 1: Transactional Replication

Exercise 1: Create a Publication

Exercise 2: Updating Subscribers and Queued Updates

Module 2: Merge Replication

Exercise 1:Horizontal Data Filtering with User-defined Functions

Exercise 2: Creating a Pull Subscription

Exercise 3: Interactive Conflict Resolution

Microsoft SQL Server 2000

Hands-On Labs

Information in this document is subject to change without notice. The example companies, organizations, products, people andevents depicted herein are fictitious. No association with any real company, organization, product, person or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form orby any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written licenseagreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

2000 Microsoft Corporation. All rights reserved.

Microsoft, MS-DOS, MS, SQL Server, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in theU.S.A. and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Overview

Replication is an important and powerful technology for distributing data and some types of database objects (stored procedures, views and user-defined functions) across an enterprise. The replicationtechnology in Microsoft SQL Server allows you to make duplicate copies of your data, move those copies to different locations, and synchronize the data automatically so that all copies have the same data values.

SQL Server Replication uses a publish and subscribe metaphor. The publisher, or owner of the data to be replicated, defines articles (analogous to tables in a database) that will beavailable to subscribers, or those locations receiving copies of the original publication.

Prerequisite: Configuring your Server for Replication

Before starting either module, be sure to complete the prerequisite exercise of configuring SQL Server for replication.

Module 1: Transactional Replication

Transactional replication provides forloose consistency between a publisher and subscriber when your application demands not just identical data at different sites, but the necessity to mirror each and every data update, addition or deletion, so you can reliably track every change to your publication in close to real-time.

What You Will Learn

After completing this lesson, you will be able to:
•Configure a SQL Server for distribution, publication and subscribing
• Set up a transactional publication and subscriber
• Implement queued updating subscribers

Module 2: Merge Replication

The merge replication model allows many or all subscribers to a publication, as well as the publisher, to make updates to replicated data. In any environment where...