I am working on Django app on branch A with appdb database in settings file. Now I need to work on another branch(B) which has some new DB changes(eg. new columns, etc). The easiest for me is to point branch B to a different DB by changing the settings.py and then apply the migrations. I did the migrations but I am getting error like 1146, Table 'appdb_b.django_site' doesn't exist. So how can I use a different DB for my branchB code without dropping database appdb?
The existing migration files have information that causes the migrate command to believe that the tables should exist and so it complains about them not existing.
You need to MOVE the migration files out of the migrations directory (everything except init.py) and then do a makemigrations and then migrate.
How to point Django app to new DB without dropping the previous DB?