I need a solution to synchronize data on a real time basis from MS SQL Server to a MySQL database.
My current set up:
MS SQL server is on my local server (windows server with internet access)
MySQL database is on a web hosting environment (VPS on CentOS)
Note: I will set up a empty database on MYSQL. Developer will need to ensure the entire MS SQL database is converted into MYSQL database and thereafter keep the data in sync.
I will provide a couple of MS SQL queries for you. (meaning you need to convert these queries for use in MYSQL) And you will setup a PHP webpage to display the result of these queries accordingly. This is for the purpose of checking that the data is synchronized on a real time basis.
The method or tool used needs to consider the below:
-Fastest processing time
Please note. When you bid, please explain the method or tool used for my consideration. Priority is given to developer who follows this instruction and provide the relevant info for this project.