Joe Danyi
asked on
MSSQL 2008 with mySQL webservers
I know this question seems abit counter intuitive but id like to work with the licensees I currently have, I have a MSSQL Enterprise 2008 and I currently have several Wordpress Sites using MySql, what is the best Methodology or setup to have incoming changes to be made to the MSSQL database and push them to all the other servers. IE a change is made on 1 MYSQL server and that change is pushed to the other MySQL servers using MSSQL.
Dave Baldwin
I don't think there is any good method for doing that. Wordpress does not have any code to communicate with Microsoft SQL Server. The datatypes for MySQL and MSSQL are not 100% compatible either.
What exactly are you looking to push from ms SQL to the MySQL? Are all the Wordpress sites related, I.e. MySQL master/master circular replication?
ASKER
the entire MySQL database it has about 6 WordPress sites and 2 other sites 1 help desk site, im just looking to sync the tables etc.. not perform any data manipulation or editing on the MSSQL server.
Your need is extremely vague still.
What data from ms SQL do you need to get into MySQL..
What coding skills do you have, activeperl installed on the Windows platform includes a connection to ms SQL, MySQL.
You could use perl to connect to both ms SQL and MySQL and perform the query on one, while inserting/updating the other....
Look at ssis packag, linked databases............
What data from ms SQL do you need to get into MySQL..
What coding skills do you have, activeperl installed on the Windows platform includes a connection to ms SQL, MySQL.
You could use perl to connect to both ms SQL and MySQL and perform the query on one, while inserting/updating the other....
Look at ssis packag, linked databases............
ASKER
Well i would like to "Sync" so both pull and push between MySQL and MSSQL, At current i am open to all solutions, i did try having a linked database this didn't work as I would have hoped. i could perform query's on tables, however , none of the backup functionality worked.
My question really boils down too, am i going to have to write extensive code in order to sync databases, or is there some kind of known methodology for MSSQL and MySQL to work together?
I will have to look into activeperl and see if that can Sync Databases.
My question really boils down too, am i going to have to write extensive code in order to sync databases, or is there some kind of known methodology for MSSQL and MySQL to work together?
I will have to look into activeperl and see if that can Sync Databases.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.