Обсуждение: aws sct/dms versus ora2pg

Поиск
Список
Период
Сортировка

aws sct/dms versus ora2pg

От
Ayub M
Дата:
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.

Re: aws sct/dms versus ora2pg

От
Gilles Darold
Дата:
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/