Support for MSSQL (django-pyodbc)

[nick@…]

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

[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

[andrew]

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...

[tom]

See also: ​http://code.google.com/p/django-mssql/

[andrew]

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.

[andrew]

Err, I meant the other milestone. Ahem.

[Andre Duarte]

There is one implementation. It worked for me

​http://bitbucket.org/andrewgodwin/south/src/01cf294a3f86/south/db/sql_server/pyodbc.py

[andrew]

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