System:
- Windows 7 32-bit
- xampp-win32-1.7.1 (php-5.2.8)
- sqlsrv 2.0 driver
- SQL Server 2008 enterprise

Installed module Data Admin UI from module data 7.x-1.0-alpha3

Then go to: admin/structure/data/adopt

The error is:

( ! ) Fatal error: Class 'SchemaDatabaseSchema_sqlsrv' not found in D:\applications\htdocs\drupal\sites\all\modules\contrib\schema\schema.module on line 173
Call Stack
#	Time	Memory	Function	Location
1	0.0010	62968	{main}( )	..\index.php:0
2	0.5634	26893888	menu_execute_active_handler( )	..\index.php:21
3	0.5689	27284512	call_user_func_array ( )	..\menu.inc:517
4	0.5689	27284560	drupal_get_form( )	..\menu.inc:517
5	0.5689	27284656	drupal_build_form( )	..\form.inc:123
6	0.5690	27286616	drupal_retrieve_form( )	..\form.inc:331
7	0.5690	27288656	call_user_func_array ( )	..\form.inc:787
8	0.5691	27288656	data_ui_adopt_form( )	..\form.inc:787
9	0.8070	31142248	schema_dbobject( )	..\data_ui.admin.inc:252
CommentFileSizeAuthor
#1 schema-1540608-1.patch9.03 KBdmitriy.trt

Comments

dmitriy.trt’s picture

dmitriy.trt commented
Title: Fatal error Class 'SchemaDatabaseSchema_sqlsrv' not found » SQL Server support
Version: 7.x-1.0-beta3 » 7.x-1.x-dev
Category: bug » feature
Status: Active » Needs work
StatusFileSize
new schema-1540608-1.patch9.03 KB

SQL Server is not supported by Schema module at the moment. Here is the patch with basic support. The following is not supported yet (all other features should work, but I can't give any guarantees):

  • Unique indexes. They are implemented using computed columns in sqlsrv Drupal driver, so I'm not sure how to support them.
  • Indexes with specified limit on the column. Just not needed for our case.
  • Precision & scale extraction. For the same reason.

This patch needs more work before committing, but at least it can be used as a starting point.

warpedgeoid’s picture

warpedgeoid commented

Dmitriy.trt, has any additional work been completed to imporove SQL Server support? I recently installed Schema 7.x-1.0-rc1 and it caused Drupal to fail to render on the Status Reports page; no errors, just an empty white page. Has this patch been merged or are you still in need of testers?

dmitriy.trt’s picture

dmitriy.trt commented

We've stopped development, because current state was enough for us. Feel free to improve it. As I can see, the patch was not yet merged and it needs a bit more work (see list of missing features in #1).

alibama’s picture

alibama commented
Issue summary: View changes

testing on sql server 2012 and not seeing anything.... wsod and no error lo - just in case anyone else is following this path