Ticket #46 (closed enhancement: fixed)

Opened 7 years ago

Last modified 6 years ago

Support for MSSQL (django-pyodbc)

Reported by: nick@… Owned by: andrew
Priority: major Milestone: The Future
Component: databaseapi Version:
Keywords: Cc:


django-pyodbc <http://code.google.com/p/django-pyodbc/> provides support for MS SQL Server 2005, via FreeTDS / UnixODBC

Ideally, south should support this too

Change History

comment:1 Changed 7 years ago by nick@…

In order to get a syncdb to run, create the directory south/db/sql_server/, and create an empty init.py

Then, in the new directory create pyodbc.py

from django.db import connection
from south.db import generic

class DatabaseOperations(generic.DatabaseOperations):
    django-pyodbc (sql_server.pyodbc) implementation of database operations.

Migrations probably won't work yet, but at least syncdb will

comment:2 Changed 7 years ago by andrew

  • Status changed from new to accepted

This will require a copy of SQL Server around in order to test against, so it might be slightly delayed until either of us bothers installing one in a VM...

comment:4 Changed 7 years ago by andrew

  • Milestone set to 0.4

There's already some preliminary support for this, as far as adding columns and tables and a few other things. It'll get more work in future, but isn't being included in 0.4.

comment:5 Changed 7 years ago by andrew

  • Milestone changed from 0.4 to The Future

Err, I meant the other milestone. Ahem.

comment:6 Changed 6 years ago by Andre Duarte

comment:7 Changed 6 years ago by andrew

  • Status changed from accepted to closed
  • Resolution set to fixed

Ah, yes, this ticket has been languishing in here. We do indeed have SQL Server support, and have had for a while.

Note: See TracTickets for help on using tickets.