Automatically synchronise two SQL servers which are being independently updated RRS feed

  • Question

  • I have a particular problem for a project I am working on.

    The project is to develop a trade website to enable web order of complex kits of parts which are currently ordered via Fax or phone ordering. The website being developed is intended to supplement the existing system not to replace it.

    Currently the manual system operators key in the ordering information into the computer system.
    The system data thus created in addition to several other source data files is used to populate SQL tables in a windows 2000 Server. These SQL tables provide a snapshot of the current order state.

    The website being developed for lack of suitable ADSL / Cable links is being located on a remote server.
    The remote server will be initially synchronised from the local windows 2000 servers SQL tables

    On D-Day the SQL Tables on both the local and remote servers will be identical.

    When the web order system goes live the web servers SQL tables will be updated with newly taken web orders.
    The local server SQL tables will be continue to be updated with manual orders taken.

    The web design is such that, post order, both manual and web customers will be able go on the website and track their order online.

    There is therefore a requirement to keep the SQL tables on both local and web servers up to date with current ordering status. It is anticipated that the synchronisation if possible can be achieved automatically overnight during the quiet hours.

    My question is, is it possible to synchronise the SQL tables automatically using mirrorring or other techniques such that the local and remote servers update the SQL tables in a way that does not end up corrupting one anothers SQL tables?

    How would one go about keeping the two sets of SQL tables in sync?
    What techniques would be required for this?

    Secondly is Windows 2000 Server up to the job for this?
    Would we need to move to Windows 2003 Server or Windows 2008 Server or later?

    I hope you are able to help.

    Thursday, January 6, 2011 2:29 PM


  • you can either use SQL Replication (Merge replication comes to mind) or Sync Framework for your scenario.
    Tuesday, January 18, 2011 11:20 AM

All replies