I have two offices in two different countries. One office is in developing country with low internet speeds. We are currently running MSSQL servers in both offices. The servers are connected via a VPN and use MSSQL real time merge replication to keep current versions of the data in both offices. This is done because the internet connection in office two is too slow to access the database in office one. The same application is run in both offices and connects to the local version of the data. Merge replication then syncs changes made in both offices so that changes made in office one are replicated to office two and vice versa.
For a variety of reasons I'm looking to switch to the free version of MySQL. I'm wanting an expert to propose and demonstrate a possible solution to achieve the required merge replication using MySQL. If the initial tests are successful then the bidder will also assist with the implementation of the solution (for an additional cost). Therefore, please bid on the proposal and demonstration only.
9 freelancers are bidding on average $283 for this job
I can make a script that replicates or migrates database and its tables and also its contents from mssql to mysql and update contents of the tables. I can do this in just a day just send to me the database.