65

According to the documentation here: https://docs.djangoproject.com/en/1.8/topics/migrations/ it says:

migrate, which is responsible for applying migrations, as well as unapplying and listing their status.

and

makemigrations, which is responsible for creating new migrations based on the changes you have made to your models.

From what I understand, I first do

makemigrations

to create the migration file and then do

migrate

to actually apply the migration?

Do note though that I just began my Django project and I added my app to my "installed_apps" list. After that, I did

python manage.py runserver

and it said

You have unapplied migrations; your app may not work properly until they are applied. Run 'python manage.py migrate' to apply them.

It didn't mention anything about running makemigrations.

SilentDev
  • 20,997
  • 28
  • 111
  • 214
  • 5
    The django framework needs a few database tables - example: session, content_type, site which it already has created migrations for. The message you see is that those "default" migrations are not applied yet. So, you would run migrate before starting the server for the first time – karthikr May 01 '15 at 01:07
  • @karthikr Oh okay. So in my situation, since I added my app to "installed_apps" even before doing the initial "migrate", does that mean I should now run "makemigration" first and then do "migrate"? – SilentDev May 01 '15 at 01:15
  • 1
    Yes. That is when the migrations for your app are created. The next step is to apply those created migrations – karthikr May 01 '15 at 01:20

9 Answers9

90

According the Polls tutorial:

  1. python manage.py makemigrations <app>: Create the migrations (generate the SQL commands).

  2. python manage.py migrate: Run the migrations (execute the SQL commands).

Hakim
  • 3,225
  • 5
  • 37
  • 75
35

As Django's documentation says Migrations are Django’s way of propagating changes you make to your models (adding a field, deleting a model, etc.) into your database schema.

makemigrations basically generates the SQL commands for preinstalled apps (which can be viewed in installed apps in settings.py) and your newly created apps' model which you add in installed apps.It does not execute those commands in your database file. So tables doesn't created after makemigrations.

After applying makemigrations you can see those SQL commands with sqlmigrate which shows all the SQL commands which has been generated by makemigrations.

migrate executes those SQL commands in database file.So after executing migrate all the tables of your installed apps are created in your database file.

You can conform this by installing sqlite browser and opening db.sqlite3 you can see all the tables appears in the database file after executing migrate command.

Rajat Bhatt
  • 1,545
  • 15
  • 18
24

As we know Django is an ORM (Object Relational Mapping). When we use the command:

python manage.py makemigrations [app_name]

It will generate the sql command to create the table corresponding to each class you made in models.py file. then the command:

python manage.py migrate [app_name]

will create the table in database using the commands which have been generated by makemigrations.

For example, if we make a model class-

from django.db import models

class Person(models.Model):
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)

The corresponding sql command after using makemigrations will be

CREATE TABLE myapp_person (
"id" serial NOT NULL PRIMARY KEY,
"first_name" varchar(30) NOT NULL,
"last_name" varchar(30) NOT NULL
);

and using above command, table will be created in the database when we use migrate.

bSr
  • 1,410
  • 3
  • 16
  • 30
5

You should run the command -migrate- after adding a new app under the INSTALLED APPS section in the settings.py file in order to synchronize the database state with your current set of models. Assuming you've already modified the models.py file.

When you run -makemigrations- it packages up changes to your model into individual migration files.

Normally you would first run makemigrations and then migrate.

See documentation on Django Models

Sevle
  • 3,109
  • 2
  • 19
  • 31
4

It is necessary to run both the commands to complete the migration of the database tables to be in sync with your models.

makemigrations simply analyzes your current models for any changes that would be out of sync with your database and creates a migrations file that can be used to bring the in sync. If left at this point, your models would still be out of sync with your database possibly breaking your code that queries the database.

migrate is the command to "Make It So!" and apply the changes noted during the makemigrations phase.

Source

Toms Code
  • 1,439
  • 3
  • 15
  • 34
3

Make migrations : Basically it generate SQL Commands for preinstalled apps and newly created app model which you added in installed app. It dose not executed SQL commands in your database. So actual tables are not created in DB.

Migrate : Migrate execute those SQL commands which are generated by make-migration in Database file . So after migrate all the tables of installed app are created in DB.

Arti
  • 39
  • 2
2

This is django's replacement for the old manual south way of making migrations, they can be used to catalog changes in your models and write out changes that will take place in the db.

Migrate is basically the old syncdb but it takes into account all the migrations made by makemigrations.

Mikeec3
  • 649
  • 3
  • 9
2

makemigrations: creates the migrations (generating SQL Command- not yet executed)

migrate: run the migrations (executes the SQL command)

But in your case, Django is asking you to migrate the DEFAULT migrations which should run before first running of server. This would have been the same warning without even creating the first app.

hillsonghimire
  • 485
  • 5
  • 13
2

According to the second tutorial of the django tutorial series. Migrations are:

The migrate command takes all the migrations that haven’t been applied (Django tracks which ones are applied using a special table in your database called django_migrations) and runs them against your database - essentially, synchronizing the changes you made to your models with the schema in the database.

So pretty much all it does is:

  1. When you execute the make migrations command you're saving the 'instructions' to mysql
  2. When you execute the migrate command, you're executing those same instructions
Dr4kk0nnys
  • 697
  • 7
  • 13