Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to design a file-based replication process?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Flowing Fount of Yak Knowledge

1242 Posts

Posted - 03/15/2011 :  15:51:34  Show Profile  Visit timmy's Homepage  Reply with Quote
Hi all,

I have a requirement for a distributed replication system in SQL 2000. This system will have a central node and 700+ subscribers over an unreliable WAN. The fundamental requirements are:

  • One-way replication from central node to subscribers

  • Must use file-based transfers (no getting around this one, unfortunately)

  • Small amounts of data to be moved periodically (not a constant stream of updates). Probably 100kb per day would be usual.

  • Must be as close as possible to real-time

  • Must have some method of reconciling with the central system to prevent tampering with the remote database (it's a long story, but preventing tampering altogether would be next to impossible)

I have an idea on how to get the replication to work, but not sure about the reconciliation bit. Is there any easy way to 'checksum' an entire database?

Thanks in advance,

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000