Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ozSQLServer
Starting Member
32 Posts |
 Posted - 2011-12-09 : 00:58:33
|
| Hi,I've learnt on Change Trackingand successfully implemented it on a test environment.What isn't clearly yet to me is, when in practical Change Tracking could be used?What I understood from msdn, it can be used to synchronize data changes in a table in a database to some other data store, but isn't that what can be done by replication?Cheers,Cheers,ozSQL |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-13 : 12:48:38
|
| Change data capture used for auditing purpose .now no more complex codes (triggers) and third party app are required to trace the DML changes on table.As per BOL:Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes. With change tracking integrated into SQL Server, complicated custom change tracking solutions no longer have to be developed. |
 |
|
|
|
|
|
Typical Usage of Change Tracking