[GTALUG] Migrating from MySQL to Postgres

Myles Braithwaite 👾 me at mylesb.ca
Tue Nov 7 10:20:57 EST 2017


Anyone have some recent first hand experience migrating a MySQL database
to Postgres and would like a coffee and cookies in exchange for your
case study?

I'm working on a project that we are trying to get up and running on
Postgres (as we plan on hosting it on Heroku's awesome Postgres
instances) and have found that the existing migrate utilities (mysqldump
--compatible=postgresql[0], pgloader[1], random sed files, etc) haven't
produced the desire results.

[0]:
<https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_compatible>
[1]: <http://pgloader.io/>



More information about the talk mailing list