Data Base Migration from Data schema
We are working DB Migration project where we planning to move Pega Data Tables from Oracel to postgres . we planned to do it through Pega Product rule and Data flow rule but later found many challenges in this approach as currently pega not having capability to audit how many records moved and how to move delta records of an already existing table .( dont want to move using individual pzinskey instances as many tables are created external and dont have pxcreatedatetime in them). Looking for advise how to take migrate delta data ? can we do it from pega side or any third party tool which will help us in this requirement.
Aaseya IT Solutions
IN
@RohitA13 I have used Data flows earlier and was able to meet these requirements. Even though pxcreatedatetime is not there it should be having a primary key. In case of primary key, you can use insert new records or update existing record approach.
But on another note, your DBA should be able to provide a guidance on tools. 