What is the best way to migrate data in django

django data-migration
hamdiakoguz picture hamdiakoguz · Oct 6, 2008 · Viewed 21.3k times · Source

After making some changes in my models (eg. new field in a model and a new model) what is the best way of reflecting these changes to my populated database?

PS: I wanted to see many solutions in one place rated. Apparently more solutions are already listed here.

Answer

shacker picture shacker · Oct 16, 2008

Another technique is to use the dumpdata and loaddata arguments to manage.py, killing your database in-between:

  1. python manage.py dumpdata > dump.json
  2. With an external tool, drop any affected tables, or kill the whole db
  3. python manage.py loaddata dump.json

See manage.py docs for more.

Related questions

What is the best approach to change primary keys in an existing Django app?

I have an application which is in BETA mode. The model of this app has some classes with an explicit primary_key. As a consequence Django use the fields and doesn't create an id automatically. class Something(models.Model): name = …

Read More
Loading initial data with Django 1.7 and data migrations

I recently switched from Django 1.6 to 1.7, and I began using migrations (I never used South). Before 1.7, I used to load initial data with a fixture/initial_data.json file, which was loaded with the python manage.py syncdb command (when …

Read More
Django: What are the best practices to migrate a project from sqlite to PostgreSQL

I need to migrate a complex project from sqlite to PostgreSQL. A lot of people seems to have problem with foreign keys, data truncature and so on... Is there a full automated utility ? Do I need to check some data …

Read More