StandardCDC- mirrortable query

Dec 5, 2012 at 8:16 AM

HI ,

After enabling StandardCDC for a table (employee) system creates a mirror table in same Database.

i want to create a mirror table in another database and capture the changes.

kindly suggest me do it

Thanks in advance.




Dec 5, 2012 at 6:56 PM

Hi Mahendiran

This should be straight-forward. There is no 'other database' specified in the dynamic sql generated by the procs so the current database context is assumed.

Simple include the mirror database name (a somewhat confusing nomenclature) before the schema (SCDC) and ensure that the user/database logon this will execute under from within the SCDC trigger has atleast (or only) permissions to write to it. 

Given your current problems with SCDC, I suggest you leave this further complication for later when you've satisfied yourself that SCDC will work for you and when you understand it thoroughly before deviating from this project path when it will be harder for folks here to support you.

If you just want to move these audit tables out of the way, I suggest you look at SQL TreeO and create SCDC folders.