<story><title>Migrating 1200 databases from MySQL to Postgres</title><url>http://psyenix.blogspot.com/2017/08/migrating-1200-db-from-mysql-to-postgres.html</url></story><parent_chain></parent_chain><comment><author>seanharr11</author><text>I wrote an open source tool that migrates between any 2 relational databases.&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;seanharr11&amp;#x2F;etlalchemy&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;seanharr11&amp;#x2F;etlalchemy&lt;/a&gt;&lt;p&gt;This includes automatic migration of the schema, constraints, indexes and obviously data. It leverages fast bulk loading tools like mysqlimport, and PostgreSQL&amp;#x27;s COPY FROM. It doesn&amp;#x27;t need any config. Just plug and play.&lt;p&gt;The tool uses SQLAlchemy to abstract column types, and handles various column type conversions between any flavor of SQL.&lt;p&gt;The one thing it needs are tests, and scalability support for tables bigger than a few GB!</text></comment>
<story><title>Migrating 1200 databases from MySQL to Postgres</title><url>http://psyenix.blogspot.com/2017/08/migrating-1200-db-from-mysql-to-postgres.html</url></story><parent_chain></parent_chain><comment><author>willcodeforfoo</author><text>I&amp;#x27;m working on migrating an app right now (just one MySQL database) but can highly recommend [pgloader](&lt;a href=&quot;http:&amp;#x2F;&amp;#x2F;pgloader.io&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;pgloader.io&amp;#x2F;&lt;/a&gt;). It has a bunch of built-in and configurable rules to cast different column types to PostgreSQL and the developer has been very responsive in helping me make weird column types work, too.</text></comment>