How to achieve CDC using ora2pg

[tilatali]

Hi Darold,

You have mentioned only below option

New command line option --cdc_ready to use current SCN per table when exporting data and register them into a file named TABLES_SCN.log This can be used for Change Data Capture (CDC) tools.

• Add option -C | --cdc_file to be able to change the name of the default file used to store/read SCN per table during export. Default is TABLES_SCN.log in the current directory. This is the file written by the --cdc_ready option.

But May i know the correct execution steps to achieve the CDC feature using ora2pg please. I know it can't work like other CDC tools but if i want to migrate only incremental changes from oracle to postgresql, what would be the sequence of steps.

1. Full load the table without SCN
2. Note the current_SCN value in oracle DB and then insert some value in source table
3. run the ora2pg commond like "ora2pg --cdc_ready"

but this is not migrating only incremental changes, this is migrating full table's data.

Could you please help us here Thanks, Manoj

[darold]

This is a work in progress, there's no procedure established to achieve what you want to do. It is in my todo list.