Hello everyone, I have a question about migrating from mysql to

Question

Hello everyone, I have a question about migrating from mysql to

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?

#programming #russian

0

23.10.2023

7 ответов

23 просмотра

Sercan Автор вопроса

DB
Try Ora2pg for functions and stored procedures mig...

for mysql to postgres?

0

23.10.2023

DB

Yeah but can be used for mysql aswell

0

23.10.2023

Sercan Автор вопроса

DB
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.

0

23.10.2023

DB

Sercan
Thank you. It was an option I never considered. ...

👍

0

23.10.2023

DB

Sercan
Thank you. It was an option I never considered. ...

Ora2pg can help migrate data as well if DB size is considerably small/medium

0

23.10.2023