Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David McKinney » Imaginative Auditing with Rollback (Undo) and...

22 posts, Page 3 of 3

«««1 2 3

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I

Rate Topic

Display Mode

Topic Options

Author

Message

Vladimir Sotirov

Posted Saturday, June 20, 2009 1:36 PM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, August 02, 2012 6:21 PM
Points: 799, Visits: 121

Good Article David,
do you think you can change the method to use CDC in SQL2008 instead of triggers? We all know why we do not want to use triggers.
The CDC do not give you the SQL that needs to be run to roll forward and roll backward. IF you make the article for SQL2008 this will still has its value.

Post #738889

nellisjp

Posted Wednesday, December 07, 2011 1:28 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 02, 2013 8:32 AM
Points: 87, Visits: 279

Seems to me that this could be leveraged as a home-grown replication solution between non-homogeneous databases. Just need an application at either end to ship-and-apply the changes.

Post #1218212

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions