On: Migrating 1200 databases from MySQL to Postgres

[seanharr11]

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!

[mkez00 → seanharr11]

Going to give this a try. Thanks for posting!

[icelancer → seanharr11]

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

[seanharr11 → icelancer]

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