SQL Server Performance

Synchronizing Databases

Discussion in 'SQL Server 2008 Replication' started by bhreddy.222, Jan 19, 2011.

  1. bhreddy.222 New Member

    I have two data bases DBMaster(tblMaster) and DBChild(tblChild).
    - tblChild can import subset of records from tblMaster and can have its own data records also.
    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. How do i get this Synchronization?
    Please suggest any tools are available to do this, can this be done using Replication.
  2. RamJaddu Member

    with your requirement you should look for setup up SSIS package or write T-SQL scripts to synchronize data.
  3. satya Moderator

    How are you controlling the update of tblMaster records?
    DO you have referential integrity between these 2 tables?
    In that case you can control the update within your TSQL statements to update the child tables based on the master table changes.

Share This Page