Django with database on SQL Server

Question

I have a project working with sqlite3 (default database) and I am trying to use Microsoft SQL Server instead.

I was following these steps and I have already installed the pymssql package, but right now I don't know what I need to do to connect my Django to my SQL Server database.

you need to add DATABASE settings( credentials) to your settings.py — ans2human
– ans2human, Commented Feb 22, 2019 at 13:06
In addition to @ans2human, you could also follow this doc: django-mssql.readthedocs.io/en/latest/… — TechSavy
– TechSavy, Commented Feb 22, 2019 at 13:11
You can use MSSQL database backend. find more documentation from here — Devang Padhiyar
– Devang Padhiyar, Commented Feb 22, 2019 at 13:31

ans2human · Accepted Answer · 2019-02-22 13:16:52Z

1

One way is to use django-mssql package:

Install the package via PIP : pip install django-mssql

Add relevant settings of your DB to settings.py.

DATABASES = {
'default': {
    'NAME': 'my_database',
    'ENGINE': 'sqlserver_ado',   # <-- don't change this as this is module name 
    'HOST': 'dbserver\\ss2012',
    'USER': '',
    'PASSWORD': '',
 }
}

Do not include a django.db.backends. prefix. That is only for core backends that are included with Django, not 3rd party backends.

answered Feb 22, 2019 at 13:16

ans2human

2,3571 gold badge18 silver badges32 bronze badges

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

1 Comment

Pedro Mariz Over a year ago

already try that and is always giving me this error django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available database backend.

Kristiyan Gospodinov · Accepted Answer · 2019-02-22 13:32:35Z

1

In order the ORM to work as expected you have to use a database backend. You can't just set the driver to pymssql because the ORM doesn't know how to use it. Keep in mind that at this point there is no official myssql database backend released by Django. django-mssql might do the job but the last supported Django version is 1.8.

I suggest you to try https://pypi.org/project/django-pyodbc-azure/. It looks like it supports Django 2.1. But you will have to use pyodbc instead of pymssql.

edited Feb 22, 2019 at 13:32

answered Feb 22, 2019 at 13:23

Kristiyan Gospodinov

5865 silver badges10 bronze badges

2 Comments

Pedro Mariz Over a year ago

already try that , and is allways giving me this error ` The data source name was not found and no default driver(SQLDriverConnect) was specified)`

Pedro Mariz Over a year ago

well i already found the solution and put DRIVER={SQL Server} but now i have another error that i cant import the models to the sql

Collectives™ on Stack Overflow

Django with database on SQL Server

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related