Chris Stewart
Chris Stewart

Reputation: 1689

Wordpress with SQL Server

I was wondering if there is any way wordpress (php) can be used to write to a SQL Server . Simpler the better. We are currently looking at transferring our website over a CMS (preferrably wordpress) but we have all SQL Server databases.

Thanks for the insight guys.

Upvotes: 1

Views: 5911

Answers (4)

Ben Lobaugh
Ben Lobaugh

Reputation: 374

You will want to be careful when following the Running WordPress on SQL Server tutorial mentioned by Remus Rusanu. It relies in a pre-built version of WordPress that is not up to date with the latest releases. It is safer to use the WP Db Abstraction plugin directly from the WordPress.org site.

Upvotes: 1

Ben Lobaugh
Ben Lobaugh

Reputation: 374

This is actually quite simple with the WP Db Abstraction plugin. I have been using it for months and it seems quite solid. After you extract the WordPress archive but before running the installer you will need to edit your wp-config.php file your database connection details. From that point it is just like running WordPress with MySQL. Fire up the browser and the installer will complete the setup of WordPress

http://wordpress.org/extend/plugins/wordpress-database-abstraction/

P.S. This works great with SQL Azure as well

Upvotes: 3

Remus Rusanu
Remus Rusanu

Reputation: 294307

There is a detailed step by step how-to at Running WordPress on SQL Server. It allows you to run on both standalone SQL Server or on a SQL Azure database.

Upvotes: 0

Narcis Radu
Narcis Radu

Reputation: 2547

You may start looking at http://code.google.com/p/wordpress-mssql/.

My advice is to try a different approach that will avoid wordpress hacks.

Upvotes: 0

Related Questions