I have a table in Oracle Database and the same table in PostgreSQL Database. Structure of the table is different, so I have mapping in replicat to resolve fields mismatch. I want to make some changes to the structure of the table on Oracle site. As I know there's no way to automatically replicate DDL changes between Oracle and PostgreSQL databases. So I have to perform all changes manually. Is this the right way to perform this?
- Stop application on both sites to prevent data changes in the table
- Stop extracts/replicats for the table
- Delete trandata for the table
- Add columns in the table on both sites
- Add the mapping for new column in replicat
- Add trandata for the table
- Start extract/replicat
- Start application
Is everything correct? Maybe there is something I forgot?