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 «««123

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I Expand / Collapse
Author
Message
Posted Saturday, June 20, 2009 1:36 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 5:43 PM
Points: 799, Visits: 125
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
Posted Wednesday, December 7, 2011 1:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 8:17 AM
Points: 128, Visits: 314
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 »

Add to briefcase «««123

Permissions Expand / Collapse