Migrating My WordPress Blog to Windows and SQL Server

I recently wrote an article over at http://wordpress.visitmix.com about my experience migrating my blog over to WordPress on Windows and SQL Server which went pretty smoothly. 


In the next couple of days I’ll go ahead and switch the DNS to my new server at Discount ASP.

Although I’ve been running web site and apps on LAMP since the late 90’s, I’ve really been enjoying PHP on Windows and SQL Server for a number of reasons.

  1. I can develop and test on my own Windows 7 machine or Virtual Machines using SQL Server Express R2 which is FREE.
  2. IIS is really easy to administer.
  3. The Web Platform Installer makes getting up and running simple.
  4. Connecting to SQL Server on my host via SQL Server Management Studio makes developing and managing my database really productive.
  5. Advanced SQL Server features like Spatial and Reporting Services give me a platform for building even more powerful apps.

Some of the things I really like about running on LAMP and miss on Windows include.

  1. SSH access for moving files.
  2. Wealth of information online related to issues when working with LAMP.

There are some tradeoffs but I’ve found the benefits outweigh the downside.  I’ve worked at Microsoft for three years without switching my site so it’s not just because they pay me although it does help :)  All in all, this has been a really good experience and I’d encourage you to give it a try.

11 thoughts on “Migrating My WordPress Blog to Windows and SQL Server

  1. Pingback: Wordpress Belarus » Blog Archive » Migrating My WordPress Blog to Windows and SQL Server | Zach …

  2. Thanks a lot for yet another super article. I am always trying to find good articles. Thanks for creating this article. It’s just what I was trying to find. Truly wonderful post.

  3. Hey I just wanted to let you know, I really like the piece of writing on your web site. But I am utilising Chromium on a machine running version 9.10 of Xubuntu and the look and feel is not quite proper. Not a big deal, I can still basically read the articles and look for for information, but just wanted to inform you about that. The navigation bar is kind of difficult to apply with the config I’m running. Keep up the good work!

  4. Thanks for sharing excellent informations.Your website is very cool.I am impressed by the details that you have on this website.It reveals how nicely you understand this subject.Bookmarked this web page, will come back for extra articles.You, my friend, ROCK! I found just the information I already searched everywhere and just could not come across.What a great website

Leave a Reply

Your email address will not be published. Required fields are marked *