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.