I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with WordPress, so I had to move it over to IIS. That still had MySQL involved and the CTO of the company wants it to run on SQL instead. I have Installed a fresh copy to mess around with from here "wordpress.org/ wordpress-3.4-IIS.zip" then I downloaded and installed db-abstraction. That done, I extracted them to the location I wanted (wordpress/[site]).
- Log into your current site and export your data as an xml file
- Disable all your current plugins
- Back up your existing
- Download the plugin package.
wp-db-abstraction.phpand the wp-db-abstraction directory to
wp-content/mu-plugins. This should be parallel to your regular plugins directory. If the mu-plugins directory does not exist, you must create it.
- Put the
db.phpfile from inside the
$your_wordpress_url/wp-content/mu-plugins/wp-db-abstraction/setup-config.phpto generate your
- Install WordPress
- Log into the newly installed system and import your data
- Reinstall and test your plugins
Up to step 6 it works fine. Then when I try and go to the php page, 1) I can't set the database type from MySQL to SQL 2) about 50% of the time I get a 500 error.
I really don't know if this makes any sense to anyone. I'm sorry if I am confusing you as it really confuses me as well. Please let me know if you need more information. Thanks.