Django Inspectdb on MSSql error while trying to inspect a table

Question

I've got this error while trying inspecting a MsSql database:

# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models
# Unable to inspect table 'test_table'
# The error was: __new__() missing 1 required positional argument: 'collation'

This is the command that I've used:

python manage.py inspectdb test_table --database=some_db --verbosity=3

This is the connection in settings.py:

  'some_db':{
        'ENGINE': 'sql_server.pyodbc',
        'NAME': os.environ['name'],
        'USER': os.environ['user'],
        'PASSWORD': os.environ['pw'],
        'HOST': os.environ['db'],
        'PORT': os.environ['port'],
        'OPTIONS': {
            'driver': 'ODBC Driver 17 for SQL Server',
            'unicode_results': True

        },
    }

score 2 · Accepted Answer · answered Apr 26 '21 at 08:32

2

I've found out that there was a version mismatch between Mssql version and pyodbc version: Mssql version was not supported. I solved using django-pyodbc-azure instead of pyodbc directly!

answered Apr 26 '21 at 08:32

Ivan El Mochilero

81
6

score 1 · Answer 2 · answered Nov 11 '21 at 14:08

1

There seem to be some collation changes in djagno 3.2 that cause this issue, and unfortunately django-mssql-backend doesn't officially support django 3.2 (as of Nov 2021).

see: https://code.djangoproject.com/ticket/32767

While I am able to run django-mssql-backend with django 3.2 in most cases, I temporarily revert to django 3.1 in order to perform inspectdb

Related discussions at: https://stackoverflow.com/a/67305117/341329

answered Nov 11 '21 at 14:08

Aaron

2,409
29
18

Check out mssql-django on GitHub. It's a fork of django-mssql-backend maintained by Microsoft. – John Meinken Nov 23 '21 at 16:30

score 1 · Answer 3 · answered Nov 23 '21 at 16:28

The third-party backend django-mssql-backend still has this issue for Django 3.2. However, there is now a fork of django-mssql-backend called mssql-django that is maintained by Microsoft. This new fork does say it supports Django 3.2 and worked for me.

https://github.com/microsoft/mssql-django

score 0 · Answer 4 · answered Apr 22 '21 at 12:11

0

I had the same problem, but found the solution: The user wasn't part of the db_owner role. In other words you probably don't have enough permissions. Make the user owner of the database in your mssql.

answered Apr 22 '21 at 12:11

Willem Genuit

26
2

Django Inspectdb on MSSql error while trying to inspect a table

4 Answers4