Re: aws sct/dms versus ora2pg

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/