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.
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
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.
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.
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.