We currently capture change data via a trigger on each table that captures the Inserted and Deleted records as XML and then posts a Broker Message that ultimately puts the data in a table identifying the table that was changed and capturing the before and after images as xml columns.
We are going to upgrade this system to SQL 2008, and the developers would like to use the CDC feature of 2008 to make querying the audit data a bit simpler. Does anyone know if there is anyway to take the current audit data and load it into the CDC tables that are created when you set up a table to be audited?
Thanks,
Jeff Bradley, SQL DBA, SC Dept. Social Services