Synchronize the server database with a localhost

-1

I need to synchronize two databases so that their information is the same because of internet instability issues. I found the replication that exists in phpmyadmin, but since I use a cloud server I can not tweak its settings to convert my database into a master

    
asked by anonymous 31.08.2017 / 05:47

1 answer

0

If you can not change the settings of the computer, you can try to make a Linked Server and have a routine in the database "daughter" to from time to time gather information from this Linked Server and put in this new database. Example: Every 1 hour, this information will be entered in the new database. It will not be a real time solution, it will have an information gap, but it can be useful.

Check out this tutorial on how to create Linked Server, it is well detailed: Creating a Linked Server from SQL Server to MySQL - Unused OPENQUERY;

    
01.09.2017 / 16:31