How to Convert .sql of Mysql to postgresql

Question

My Question is the following how to convert .sql mysql to postgresql sql , so I can uploaded to postgresql database at heroku and please let it be free tool.

many thanks

Nick · Accepted Answer · 2018-03-08 11:20:03Z

2

Here are two tools for migrating from MySQL, both are actively maintained:

1) pgloader https://github.com/dimitri/pgloader. With it, conversion is just a one line:

pgloader mysql://user@localhost/dbname_in_mysql postgresql:///dbname_in_postgres

2) pg_chameleon https://pypi.python.org/pypi/pg_chameleon – this one is actually a replication system so it's suitable for systems under load.

answered Mar 8, 2018 at 11:20

Nick

2,54315 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Convert .sql of Mysql to postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related