0
I need to synchronize SQL Server (Master) with Mysql (Slave).
I have already found some ways to do this on the internet, such as the native feature of SQL Server "Linked Server" or that APP for windows Dbsync. But I wonder if you have the possibility to do this with some script in PHP or other programming language.
I’ve already googled, but I can’t find any scripts, that’s all I mentioned above. I can’t think of an algorithm that locates only the edited lines in SQL SERVER and updates the lines in Mysql.
I think something that would solve your problem would be something more complex than SQL Server itself and Mysql combined. Why don’t you just use one of the two? This would be a simple case of incremental backup/replication.
– Oralista de Sistemas
Evaluate the creation of a job in SQL Server, using the connection via Linked server. Just set the frequency at which the replication will be updated. // Is there any rule that defines what has been modified since the last sync update? // Involves one or several tables?
– José Diz
So, the use of only one bank is impractical since I have two integrated systems, each with its database (Mysql and SQL SERVER), to make Linked-server connection would be a last solution, because I don’t have a master user of SQL SERVER and I would like to be able to solve this problem with some script, even with php if possible, because then I would only put in the CRONTAB routine of linux, but my difficulty is to update the tuples, I can’t think of a functional logic.
– Bruno Fabricio Cassiamani