Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 30, 2013 2:38 PM
Points: 15, Visits: 57
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
Post #1504035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse