I wrote an open source tool that migrates between any 2 relational databases. https://github.com/seanharr11/etlalchemy https://github.com/seanharr11/etlalchemy

I wrote an open source tool that migrates between any 2 relational databases. https://github.com/seanharr11/etlalchemy 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!