Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Change Tracking Expand / Collapse
Posted Friday, October 11, 2013 8:28 AM


Group: General Forum Members
Last Login: Monday, January 19, 2015 4:33 AM
Points: 15, Visits: 58
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.
Post #1504035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse