Le 22/02/2020 à 02:07, Ayub M a écrit :
I would like to get suggestions and feedback on aws sct/dms vs ora2pg for an Oracle (on-prem) to PostgreSQL (aws rds) migration project.
One big difference between them I see is the fact that dms supports incremental loads from oracle to postgres (dont think ora2pg supports that, but I could be wrong).
Someone who researched or used these tools help list pros and cons of each approach and which is highly recommended.
Hi,
I don't know a lot about aws migration but it seems to only be
able to migrate DDL and data, ora2pg can do much more. About the
incremental data migration Ora2Pg has an experimental mode to add
the incremental feature, see DATADIFF in documentation and
ora2pg.conf. Unfortunately I still not have really used this
feature but help to test and improve it is welcome. Although as
Ora2Pg is a spare time project I guess that with the financial means of amazon their product is far
better. If you or someone else give a try to both solution
fill free to send feedback.
Regards,
-- Gilles Darold http://www.darold.net/
