Transfer data from PostgreSQL to MySQL

2020-03-25 10:54发布

Hello is there any method to transfer the table layout and data from a Postgres database to MySQL automatic?

I have to migrate the scheme anda data to MYSQL

2条回答
聊天终结者
2楼-- · 2020-03-25 11:21

The easiest would probably be to export the database (schema & data) as SQL using Postgres' pg_dump utility, then import the resulting SQL file into MySql.

It's possible that there will be some incompatibilities in the intermediate SQL, but you can almost assuredly take care of these with a find/replace in your favorite text editor.

查看更多
家丑人穷心不美
3楼-- · 2020-03-25 11:41

It is possible to do using the "Data Transfer" feature of Navicat Premium. It will not preserve foreign keys though, but the data transfers correctly with the two databases incompatibility issues resolved.

查看更多
登录 后发表回答