I have successfully split my WordPress database into two MySQL databases (using hyperDB). And it works well. Now I want to dive into the unknown and have one database use MYSQL and the other MS SQL.... is this possible?
Am I better off trying something like http://dev.mysql.com/downloads/connector/odbc/
To create a linked MySQL DB and get WordPress to connect to that.
This video makes it look pretty easy - http://www.youtube.com/watch?v=BLo1yQ_Af64?
Any thoughts greatly appreciated.