Post reply

Data Sync

  • December 16, 2015 at 3:26 am

    #307109

    Hi,

    I had databases at different...different locations, and individual locations have there own master and transactions, Is it possible to sync on these databases with each other like.

    There are 3 locations A,B & C have there own database with 10,15,100 transactions data with respective locations and 12,10,75 master data with respective locations.

    LocationTransactionsMaster

    A 10 12

    B 15 10

    C 100 75

    all the data of three locations to be synced like location A might not have transactions of location B & C, then it should sync with these 2 locations databases and made available in location A, similar with location B & C, even for master it would be same.

  • December 16, 2015 at 3:34 am

    #1846265

    Does this need to be real time, or periodical (for example nightly)? For real time, consider merge replication. For periodic, consider an ETL tool such as SSIS.

    John

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

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