Syncronizing client and server database

Posted on 2005-05-02
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

    Try to implement Merge Replication. You need UNIQUEIDENTIFIER column in each replicated table. Learn more in BOL.
    LVL 34

    Expert Comment

    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....


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now