Home arrow SQL Server arrow Page 5 - Replication: SQL Server 2000 - Part 2

Replication: SQL Server 2000 - Part 2

In this second, and final, installment, Mahesh gives us a step-by-step approach on how to implement replication across a network using SQL Server 2000.

Author Info:
By: Mahesh Kodli
Rating: 5 stars5 stars5 stars5 stars5 stars / 104
November 13, 2003
  1. · Replication: SQL Server 2000 - Part 2
  2. · Getting Started: Step-By-Step
  3. · Getting Started: Step-By-Step, Cont'd.
  4. · Code: Stored Procedure
  5. · Getting Started: Step-By-Step, Cont'd.
  6. · General Replication Performance Tips
  7. · Conclusion

print this article

Replication: SQL Server 2000 - Part 2 - Getting Started: Step-By-Step, Cont'd.
(Page 5 of 7 )

Specify the Publication Name

  • Accept other settings and create the publication:

With the above steps completed, we have published the data in the ‘Pubs’ database and have also set publication properties.

Create Snap Shot

  • Navigate to <Server>/Replication/Publications/Properties

  • Select the Status tab

  • Click on the “Run Agent Now” button.  This will create the snap shot files.

Adding Subscribers

  • Create a new SQL Server Database.  In this example I have created a new database named PubsSubscriber.
  • Right click on <Server>/Replication/Publications/Pubs:<Publication>
  • Click “Push New Subscription” to run the New Subscription wizard

  • Choose the newly created database as the Subscriber Database:

  • Set the Merge Agent schedule:

  • Choose Initialize both schema and data option and check Start the Merge agent to initialize the subscription immediately:

Since my Subscriber Database was a new database, I have chosen to initialize both the schema and the data.

Navigate through the wizard, accepting further options and click on finish to complete the wizard steps.

With the above steps completed, we have created a new subscriber database and setup the handshake between Publisher and Subscriber.

Now you can distribute the Subscriber database to its users who can ‘play’ with their own copy of data, and synchronize the data as per the rules of business.


  • To synchronize, Right click on the <Server>/Replication/Publications/Pubs:<Publication>, and click “Start Synchronization”.

blog comments powered by Disqus

- Executing SQL Server Stored Procedure from P...
- How to Search for Date and Time Values Using...
- Replication: SQL Server 2000 - Part 2
- Replication: SQL Server 2000 - Part 1
- SQL Sever: Storing Code in Binary or Text Fi...
- Execute SQL on Multiple Tables/Columns - New...
- How to Connect to a SQL Server from Visual F...
- SQL Server Hardware Tuning and Performance M...
- Primary Key on Multiple Tables – New RDBMS C...
- Migrating from Sybase to SQL Server
- What's Best for DBAs? GUI or T-SQL Comma...
- How to Perform a SQL Server Performance Audit
- An Introduction To The Bulk Copy Utility
- SQL Server Stored Procedures 101
- Building Your First SQL Server 2000 Database

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials