Advice on Change Tracking in Sql Server 2008
My client is looking for a way to do a full audit trails (full view of historical data on all tables) on the application.
Other than using the old fashioned way of having table copies or storing field name, field value, modified by, modified on etc, I was looking at using Sql Server 2008 change tracking.
Found a How-To article on msdn on the same
Has anyone used (or done a POC) Sql Server 2008 Change Tracking feature and found it to be worth it. Also if possible please specify what you wanted out of it and what you found/concluded. Any tips on the same are welcome.
[Edit]
Its been a week still no answer!
I've used CDC in a data-warehouse set up before. It's very good and saves you having to write triggers for all your tables, but I would list 2 areas of caution:
By default, there is a SQL agent job that prunes the tables every X days (can't remember the default), so you need to either override this, or ship the data elsewhere.
Scripts that drop and recreate tables (which MSSQL Management studio sometimes does) can result in your CDC tables being dropped and the data lost, so take care.
链接地址: http://www.djcxy.com/p/45000.html
上一篇: 绘制SVM分类图时出现错误