Yesterday if you were visiting my blog you may have noticed a few moments where it was unavailable. During that time I was migrating my blog so that it would run on the Microsoft stack. This includes running on Windows Server 2008 R2, IIS 7.5, and SQL Server code name Denali CTP 3.
When I originally installed WordPress (a year or so ago) on Windows Server 2008 R2 I used the Microsoft Web Platform Installer. This is a great tool that simplifies the installation of many Microsoft and open source applications on Windows. With just a couple clicks I was able to install PHP, MySQL and WordPress on top of Windows Server 2008 R2.
A few weeks ago I moved the WordPress database from MySQL to SQL Server 2008 R2 by using a special database layer plug-in developed by OmniTI. This plug-in enables WordPress to use Microsoft SQL server or SQL Azure for data storage. Prior to starting the migration process I used the out of the box WordPress export utility to save all of my blog posts, comments, and tags to a backup XML file. I then installed the SQL WordPress plug-in and completed the configuration process. This process created a new WordPress database and tables in SQL Server. I completed the migration by using the WordPress import utility to import all of my blog posts, comments and tags that I had originally saved off.
Yesterday I decided that I wanted to see how SQL Server Denali CTP3 would work with WordPress. I installed an evaluation version of Denali along side my SQL Server 2008 R2 installation. I backed up my WordPress database and restored it into the new Denali instance. A quick modification to the WordPress config file (wp-config) to update the database server name and I was up and running.
So far WordPress is running pretty well with SQL Server Denali CTP3. I plan on running this configuration going forward and ultimately upgrading to SQL Server Denali RTM when it becomes available.
A few words of warning: If you are thinking about migrating your WordPress blog off of MySQL and on to SQL Server or SQL Azure you will want to be aware of a few issues. First, the database layer plug-in is in active development and you may run into bugs or issues. I have also noticed that a few WordPress plug-ins will not work properly when you are using the database layer plug-in. I have seen other plug-ins that work well but have very minor issues that you can work around.
Below I have listed out the resources you will need if you are adventurous and wish to try running WordPress on the Microsoft stack.