Posted by dziga on August 9, 2011 at 12:09am
Wondering if anyone has experience of using Drupal 7 with a Microsoft SQL database (rather than MySQL)
The organisation I'm working for prefers Microsoft SQL database for integration issues with other systems.
Would appreciate hearing any other experiences of this type of implementation
Peter Giles
Comments
Try it
I haven't, but a few of the big names in Drupal have been working on this. My recommendation is try it out - see http://drupal.org/project/sqlsrv and try a google search if need be.
we've done some of this
Are you also using IIS or just MSSQL (w/ apache)?
We've done some of this already and are part of the microsoft partner program, so let me know what problems you're facing.
--Ryan
Ryan Cross
Drupal Development Services
ProjectPier project management and collaboration software
thanks for your help Ryan, we
thanks for your help Ryan, we are just about to start a big Drupal project and the IT provider prefers MSSQL to MYSQL - plan to implement with Apache server. Just want to know if it's be done before and we're not heading down a path that will give us insurmountable problems
For non-Drupal data
We have been using the project burgs mentioned to access MSSQL data in Drupal 7 for a month or two now.
Seems pretty tight and the only issues we ran across was oddities running stored procedures.
We gave up and used "SELECT * FROM function(args)" type statements instead but it's probably doable.
This is non-Drupal data though as we haven't shifted the core data to MSSQL yet.
Hope this helps. ;)
Doh, I recalled Microsoft
Doh, I recalled Microsoft themselves spruiking Drupal - indeed, it seems they are:
http://www.microsoft.com/web/drupal
However, even they use MySQL.
Doh, I recalled Microsoft
Doh, I recalled Microsoft themselves spruiking Drupal - indeed, it seems they are:
http://www.microsoft.com/web/drupal
However, even they use MySQL.