Syncronizing client and server database

Posted on 2005-05-02
Medium Priority
Last Modified: 2010-08-05
i have 10 clients and one server all client PC's can store data locally.
now i want to syncronize data at regular intervals of time with server database.
can we do it in SQL server 2000 or any third party softwares should be used.
all this client and server pc's are not in LAN. they are in WAN. connected through VPN.
Question by:nnRaj
LVL 13

Accepted Solution

ispaleny earned 500 total points
ID: 13911338
Try to implement Merge Replication. You need UNIQUEIDENTIFIER column in each replicated table. Learn more in BOL.
LVL 34

Expert Comment

ID: 13915229
Agree.  Install MSDE on your clients and implement merge replication with your central server.....

"UNIQUEIDENTIFIER column in each replicated table"

That will be handled when you setup replication for the first time.  You really need to plan things out though--if you have used Identity columns on any of your tables, they can give you head aches....


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question