Post reply

How to synchronize data between two tables in different databases

  • December 29, 2010 at 1:34 am

    #232811

    Hi!

    I have 2 different database (A and B) in a sql server 2008. Databse A has around 100 tables out of which i want to synchronize 15 tables from database A to database B. So if any addition/deletion/updation happens on those 15 tables then those entries should be updated on database B.

    But here the challenge is i will have different Primary key data in source and target, i.e. lets say one row is added to Database A-Table A with pk value as 10 then when i will copy that row to Database B- Table A, PK might be auto generated and can have any value other than 10. And there might be case wheere target table will not have all the fields as of source table.

    Same way i need to keep track of update and delete.

    Can anybody suggest me what will be the best solution?

  • December 29, 2010 at 2:31 am

    #1267059

    Duplicate post. Please reply here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 30, 2010 at 11:16 am

    #1267830

    I think you may be looking for something like this:

    http://blogs.msdn.com/b/sync/archive/2008/06/25/sql-server-2008-integrated-change-tracking.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

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