Post reply

synchronization

  • July 16, 2009 at 10:16 pm

    #385003

    Hi All

    I need some help to synchronize two MS SQL databases. The databases are located one in Local server and the other one in the web server.

    We need bi- directional synchronization of the databases. Is any solution to synchronize two

    databases in the SQL server.

    I need some expert advices

    Thnx in advance

    Milesh

  • July 16, 2009 at 10:24 pm

    #1025998

    MJ (7/16/2009)

    We need bi- directional synchronization of the databases. Is any solution to synchronize two databases in the SQL server.

    Can you have a look at peer to peer replication offered in sql server 2005's enterprize edition and see if it suits your requirement.


    Pradeep Singh

  • July 16, 2009 at 10:25 pm

    #1025999

    Transactional Replication perhaps?

    CEWII

  • July 17, 2009 at 5:25 am

    #1026094

    Elliott W (7/16/2009)

    Transactional Replication perhaps?

    CEWII

    Elliott,

    What about Merge replication for bi-directional synchronization.

    Tanx 😀

  • July 19, 2009 at 9:18 pm

    #1026700

    I would think that could work.

    If you go down that path sit down and desing out your replication before you start trying to implement it though. I have had much better experiences when I do this.

    CEWII

  • July 20, 2009 at 8:44 pm

    #1027391

    Thank u all

  • July 21, 2009 at 10:51 pm

    #1028090

    Make sure you don't have any conflicting primary keys.

    Tanx 😀

  • July 24, 2009 at 6:12 am

    #1029590

    If not intrested in replication you can use triggers and TSQL scripts in SQL jobs to keep your databases in sync.Though it would be good only if you are comfortable with TSQL.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply