How to install wordpress on MS SQL

I am trying to convert my wordpress site which is based on MYSQl to a MS SQL because my we have our main database through MS SQL and we are creating database driven wordpress sites. I have been able to automate all of our wordpress installation + setup through database sripts through MYSQL but all of our variables + inputs are in MS SQL.

Would it be easier to create a new database in MYSQL and migrate all of my data over from MS SQL or is there a way to have wordpress use MS SQL. I am wondering if anyone has been able to do this or has any hints. Thanks

EDIT/UPDATE: I have accomplished this by using a linked server. Here is a website if anyone else is reading this and wants to run the wordpress database by using Microsoft SQL Server Management Studio:

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

One Response to How to install wordpress on MS SQL

  1. harrylove says:

    It is definitely possible to run WordPress connecting to MS SQL Server. We are running such an instance in production at my company. Here are two posts that describe the process of using WordPress with MS SQL Server and IIS. I am using such a configuration right now on my local box.

    http://techsugar.wordpress.com/2011/03/02/how-to-install-wordpress-on-iis-7-5-using-sql-server-2008/

    http://wordpress.visitmix.com/development/installing-wordpress-on-sql-server

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>