Post reply

Data Sync between two Applications on different Database servers and sync should be done on set up tables data on both sides

  • August 27, 2013 at 4:53 am

    #277291

    Hi Everyone,

    I am in a situation where two applications are interacting from two DB servers and i need to sync the data of set up tables on both Application sides.

    Can anyone provide a feasible low cost approach.

    Thanks in advance.:-)

  • August 27, 2013 at 6:30 am

    #1645145

    Your requirements are a little sparse in your description. Can you elaborate? replication may be an option but without more details I cant advise any better.

    MCITP SQL 2005, MCSA SQL 2012

  • August 27, 2013 at 7:19 am

    #1645177

    Hi,

    There are two different application Databases on 2 different DB servers.

    One application is calling some stored procedures of other application through LINKED server.

    By this we are sourcing data from one application to other.

    While this process there are set up tables like List of Countries and this should be mapped with the same object in other application.

    So I need to keep the set up tables or list tables in Sync.

    Can you help on this.

  • August 27, 2013 at 7:34 am

    #1645194

    It may be easier to replicate the data of the tables you need using transactional replication from one database to the other. You would then not need to use linked server to call the remote procedures as you would have a copy of the data stored locally.

    MCITP SQL 2005, MCSA SQL 2012

  • August 27, 2013 at 7:56 am

    #1645210

    Are you updating on one side only? If so, transactional replication. If both sides, bi-directional transactional or merge replication might be needed.

Viewing 5 posts - 1 through 5 (of 5 total)

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