Post reply

Change Data Capture

  • August 15, 2011 at 2:07 am

    #241765

    I have implemented CDC in a test scenario. By default history tables are saved along with System tables. I want to save these tables in separate DB to other tables.

    Please help.

    Thanks in advance.

  • August 15, 2011 at 8:17 am

    #1368628

    If I am not mistaken, I do not think it is possible to change the default for CDC. It creates the tables in a new schema "CDC". If you are worried about security, you could just restrict the user rights to that schema. Or you could just have a job that will pull data across to another table.

    -Roy

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply