postgresql.
I researched some methods. I could do these operations with pgLoader and mysql_fdw. When I reviewed the old messages in this group, I saw that pgLoader was recommended by someone.
Is pgloader still a good option?
If I use pgLoader, will database objects such as stored procedures and functions also be transferred? Or Can it just transfer data?
Try Ora2pg for functions and stored procedures migration
for mysql to postgres?
Yeah but can be used for mysql aswell
Thank you. It was an option I never considered. So my understanding is this: if I just want data integration, pgLoader will do the trick. But if I want to migrate with all database objects (trigger, fn, sp, user, role), I should choose ora2pg.
Ora2pg can help migrate data as well if DB size is considerably small/medium
Thank you for your answers!
Обсуждают сегодня