Migrating 1200 databases from MySQL to Postgres

Re:Migrating 1200 databases from MySQL to Postgres by seanharr11 on Wednesday August 16, 2017 @03:44PM (#15030585)

I wrote an open source tool that migrates between any 2 relational databases.

https://github.com/seanharr11/etlalchemy

This includes automatic migration of the schema, constraints, indexes and obviously data. It leverages fast bulk loading tools like mysqlimport, and PostgreSQL's COPY FROM. It doesn't need any config. Just plug and play.

The tool uses SQLAlchemy to abstract column types, and handles various column type conversions between any flavor of SQL.

The one thing it needs are tests, and scalability support for tables bigger than a few GB!

[ Parent | on HN ]

Re:Migrating 1200 databases from MySQL to Postgres by mkez00 on Wednesday August 16, 2017 @07:11PM (#15032124)

Going to give this a try. Thanks for posting!

[ Parent | on HN ]

Re:Migrating 1200 databases from MySQL to Postgres by icelancer on Wednesday August 16, 2017 @10:20PM (#15033256)

Thanks much - going to test it between MSSQL and MySQL in a few days here!

[ Parent | on HN ]

Re:Migrating 1200 databases from MySQL to Postgres by seanharr11 on Thursday August 17, 2017 @07:03AM (#15035567)

Let me know how it goes...please open issues if you find them!

[ Parent | on HN ]