django-pyodbc-azure - How to use schemas

Question

I'm using django-pyodbc-azure (https://github.com/michiya/django-pyodbc-azure) and everything is working fine. However, when I migrate the models, a new schema called 'dbo' is created on the SQL Server database. I want to use an already existing 'sp' schema, is there any way to set the working schema?

Thanks in advance.

Answer 1

IIRC, you need to change the default schema for the user your are connecting as. If you're using a SQL Auth user called django_user:

ALTER USER django_user WITH DEFAULT_SCHEMA = [sp]

Good luck.

Answer 2

Define the db_table under the Meta class of one model as follows:

db_table = "[your_schema].[your_table]"

Answer 3

I've found that a number of answers don't seem to work any more. Instead, I use the instructions found here to set the schema when defining db_table such as it goes schema].[table. Don't open those square brackets; the important bit is the ].[ between schema and table name.

In your case, you'd need to set:

class Meta:
    managed = False
    db_table = 'sp].[tablename'