Create a New Django Web App with MS Sql Server as backend db

Recently while working with several powerapp applications we noticed that the applications were becoming slow day by day. The main reason behind this slowness is increasing amount of data validations on every single page and increase in data. We came up with the decision of creating a Django web app to replace the existing poweapp apps. Now while researching, i came to know that django doesnot have out of box support for Ms Sql Server. Also i cannot create a new DB on my server as migrating tables from old db to new db will require lot of approvals. is there a way i can utilize my existing db

i know we can use django-mssql-backend and few other 3rd party mssql packages. But will i be able to trigger storer procedure and run other sql commands and fetch data using select statements

Yes, you can definitely use your existing MS SQL Server database with Django. You need to use third-party database backend such as django-mssql-backend or mssql-django because Django doesn't provide built-in support for MS SQL Server.

You can call Stored Procedure like this:

from django.db import connection

def call_stored_procedure(param1, param2):
    with connection.cursor() as cursor:
        cursor.callproc('YourStoredProcedureName', [param1, param2])
        result = cursor.fetchall()
    return result

And also you can run Raw SQL Queries like this:

def get_data_from_sql():
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM YourTable WHERE condition = %s", [your_value])
        rows = cursor.fetchall()
    return rows

In additionally, you can use Django ORM with MS SQL Server.

I hope your good luck!

Yes, you can absolutely use your existing SQL Server database with Django by using a third-party backend like django-mssql-backend or mssql-django. These backends support stored procedures, raw SQL queries, and let you use your existing database without schema migration, thanks to Django's inspectdb and custom SQL execution methods.

pip install django-mssql-backend

Configure DATABASES in settings.py

DATABASES = {
    'default': {
        'ENGINE': 'mssql',
        'NAME': 'your_db_name',
        'USER': 'your_user',
        'PASSWORD': 'your_password',
        'HOST': 'your_sql_server_host',
        'PORT': '1433',
        'OPTIONS': {
            'driver': 'ODBC Driver 17 for SQL Server',
        },
    }
}

Use inspectdb to reverse-engineer your schema

python manage.py inspectdb > app_name/models.py

SELECT Queries:

from django.db import connection

def custom_query():
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM your_table WHERE condition = %s", ['value'])
        rows = cursor.fetchall()
    return rows
Вернуться на верх