I have changed database from postgresql to mysql, but I don't know how to transfer data from one to other.
我已经将数据库从postgresql更改为mysql,但我不知道如何将数据从一个转移到另一个。
Does anyone know any command by which I can copy/migrate my database from postgresql to mysql?
有谁知道我可以将我的数据库从postgresql复制/迁移到mysql的任何命令?
4 个解决方案
#1
32
Faced the problem a few years ago, and used pg2mysql
几年前面临的问题,并使用了pg2mysql
If I remember well I had to fix one or two things, but works quite well.
如果我记得很清楚,我必须解决一两件事,但效果很好。
#2
17
You can use the MySQL Workbench which can import from a variety of database types, including Postgres.
您可以使用MySQL Workbench,它可以从各种数据库类型导入,包括Postgres。
#3
2
Dbeaver is the perfect solution for painless migration, column to column mapping, character encoding and also opensource
Dbeaver是无痛迁移,列到列映射,字符编码以及开源的完美解决方案
#4
0
It is an old question but Dbeaver is the perfect solution for painless migration, column to column mapping, character encoding and also opensource
这是一个老问题,但Dbeaver是无痛迁移,列到列映射,字符编码以及开源的完美解决方案
#1
32
Faced the problem a few years ago, and used pg2mysql
几年前面临的问题,并使用了pg2mysql
If I remember well I had to fix one or two things, but works quite well.
如果我记得很清楚,我必须解决一两件事,但效果很好。
#2
17
You can use the MySQL Workbench which can import from a variety of database types, including Postgres.
您可以使用MySQL Workbench,它可以从各种数据库类型导入,包括Postgres。
#3
2
Dbeaver is the perfect solution for painless migration, column to column mapping, character encoding and also opensource
Dbeaver是无痛迁移,列到列映射,字符编码以及开源的完美解决方案
#4
0
It is an old question but Dbeaver is the perfect solution for painless migration, column to column mapping, character encoding and also opensource
这是一个老问题,但Dbeaver是无痛迁移,列到列映射,字符编码以及开源的完美解决方案