Move DB from Apache to IIS I've been working on a Drupal site under a LAMP configuration. My client uses SQL Server, so after I'm done with development I need to move the site over to their configuration. I work on Linux, so I have no way to test the site live (I can remotely connect to my client's server but if I want anything changed I have to go through their IT department, which is painful and slow at best).

I found this module, driver for SQL Server, but from the instructions I gather this is for a fresh Drupal install. Could it work, if I already have some work done, to move my current DB over to their server? If not, is there another option to keep working on MySQL and later migrate to SQL 2008?

I'm not familiar with SQL Server, so any help is appreciated.
Here is the way I would approach your issue:


Prepare two IIS+MSSQL servers, Staging and Production
Do a fresh install on Staging
Use tool like Features, UUID, and data migration module of your choice to move configuration and data from Development to Staging
Tie loose ends on Staging
Copy Staging to Production
Replace my dev with something less unlike production