Post reply

Synchronization

  • January 18, 2011 at 3:44 am

    #243814

    i have two data bases DBMaster(tblMaster) and DBChild(tblChild).

    - tblChild can import subset of records from tblMaster.

    Now If i update those records in the tblMaster which are also in the tblChild, this updation should be reflected or done in tblChild table also. Please suggest how do i get this Synchronization?

    Please suggest any tools are available to do this.

    Thanks in advance.

    Hari

  • January 18, 2011 at 3:48 am

    #1274569

    Have a look at transactional replication (or possibly merge replication), this should work for you

  • January 18, 2011 at 4:40 am

    #1274593

    Hi Steve,

    Thanks for the very quick reply.

    I have gone through Replication and it seems to be one should know the Data bases to be synchronized, prior .

    But in my case the data bases will be created on the fly (both DBMaster and DBChild) - then how do i Get synchronization on those records which are in both the databases.

    Please suggest any tools are available to do this.

  • January 20, 2011 at 3:43 am

    #1275763

    how will they be created 'on the fly'?

    if they are creted via t-sql scripting, you could add the code to setup the replication at the end of your create database code

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

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