[GTALUG] Migrating from MySQL to Postgres

[Jamon Camisso]

On 2017-11-07 10:20 AM, Myles Braithwaite 👾 via talk wrote:
> 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.

I haven't done this recently (in the last 2 or so years, but...), any
time I have needed to do a conversion in the past, mysql2postgres[1] has
worked well.

https://github.com/maxlapshin/mysql2postgres