Change Tracking

• stergiazotali

  SSC-Addicted

  Points: 421

  More actions

  October 11, 2013 at 8:28 am

  #284492

  Hello all,

  I have read several articles regarding the CT feature, found in SQL Server 2008. All sounds great and it seems pretty straight forward job to do . However consider the following :

  IF you are working with two databases, ie. DB A and DB B , you can use CT to track changes, but HOW would you push the changes to the DB B IMMEDIATELY the time those changes occur on the DB A?

  I won't go for a solution that involves Sql Jobs , where you would run a Job every 2-5 seconds in order to get those changes. I would prefer the Triggers effect(but without the triggers).

  To give you an idea, we are building a system, where we try to synchronise two databases and we do that by implementing triggers, I am thinking to replace this mess with CT, however, when changes occur on DB A, they have to be reflected on the DB B at the same time.

  I would appreciate your input.

  Thanks