id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2563	[patch] Full introspection functionality for ado_mssql backends	sdelatorre+django@…	Adrian Holovaty	"This patch provides full introspection functionality for ado_mssql backends.  It was tested on MSDE and SQL Server 2000 using adodbapi v. 2.0.1, Python 2.4.2, and Python 2.4.3.  Using this patch, I was able  to:
 * Obtain a list of tables from the database.
 * Obtain field information for each table.
 * Map each field to its corresponding Django model type (including !AutoFields).
 * Retrieve relationship information.
 * Retrieve Index information.

I tested this patch on two fairly large legacy databases, and the resulting model definitions were correct in both instances.

When time permits, I'll also test the patch on SQL Server Express and SQL Server 2005.

'''Note:''' This patch is dependent upon the changes in Ticket #2358.  I've tested the changes in that ticket, and so far I haven't run into any problems.  The attached patch actually improves on the introspection changes introduced that ticket.

"	defect	closed	Database layer (models, ORM)	dev	normal	duplicate			Unreviewed	1	0	0	0	0	0