Is it possible to export entries from the CDC tables?
CDC is currently too large (120Gb on a 170Gb database), leading to potential performance problems, and thus we want to archive the audit trail (no, removal is not an option).
Digging around online i could not find any pointers. Anyone have some ideas if the CDC tables can be exported?
After export i can then purge the entries in the export to shrink the database.