The easiest way to migrate a Django project from MySQL to PostgreSQL

Question

I would like to convert my Django project's database from MySQL to PostgreSQL. Unfortunately, I can't just use Django's "dumpdata" and "loaddata" management commands because my database tables are too big. I already read the article http://www.ofbrooklyn.com/2010/07/18/migrating-django-mysql-postgresql-easy-way/, but it seems that to use this method in practice I'll still need to turn it into something like a management command that iterates over available models when it copies model instances and when resets sequences. Besides, it doesn't seem very fast either because it issues save() on each model instance.

Is there a better way to migrate? Actually, I would prefer to do "mysqldump", convert the dump from MySQL to PostgreSQL format somehow and then load it to PostgreSQL. What piece of software would you recommend that could perform such dump conversion and correctly convert from MySQL data types to PostgreSQL ones, for example tinyint(1) to boolean?

Edit Thanks everyone for your help. I successfully migrated my database using https://github.com/maxlapshin/mysql2postgres utility. However, I still had to reset sequences in the resulting PostgreSQL database myself after importing the dump.

I have deleted my answer. Next time I will read for twice the question. Good luck with your migration! — dani herrera
– dani herrera, Commented Dec 5, 2011 at 12:33

dbf · Accepted Answer · 2011-12-05 12:09:50Z

3

There are several converters for it, for example this one in Ruby: https://github.com/maxlapshin/mysql2postgres

answered Dec 5, 2011 at 12:09

dbf

6,5572 gold badges43 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

linux-warrior Over a year ago

Thank you, got to try this one. I already heard about it but I didn't know that it can also generate db dumps.

Anentropic Over a year ago

I found the python rewrite of that Ruby script worked better for me: stackoverflow.com/questions/8895374/…

Burhan Khalid · Accepted Answer · 2011-12-05 13:16:17Z

0

If your dataset is large and you need to do any transformation you can use open source solutions like talend studio and the kettle project from pentaho to create a map and it will take care of the rest; but this might be overkill unless you want to do any transformation as well (or your data set is really, really big).

EnterpriseDB (the company behind postgresql) provide a data migration studio product that does this along with a guide if you want to do it yourself.

The py-mysql2pgsql python package is another option.

answered Dec 5, 2011 at 13:16

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

1 Comment

magnump0 Over a year ago

I had some experience with Talend Studio and Pentaho and I would NEVER suggest to use them for this purposes. KIS - use small, simple, yet efficient tool for specific operation. Using a hammer to nail an hear-ring isn't good idea...

Collectives™ on Stack Overflow

The easiest way to migrate a Django project from MySQL to PostgreSQL

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related