Local to Cloud DB Synch, MySQL

[a.alekizoglou]

Hi,

In our product we are planning to add Local to CLOUD MySQL DB synchronization. I am researching for the best way to accomplish that since MySQL does not have synchronization services and replication is out of the game for this issue.

What we have is Cloud MySQL database, and local MySQL embedded DB for the application. Even though for some customers the local MySQL DB is installed on a separate server as a service.

I would rather go with a VCL included in the DB. Has anyone planned and incorporated such a solution and with what tools?

[VladimirK]

Hello,

MyDAC has no synchronization tools. As an alternative, TMyDump can be used. Using TMyDump, a full database backup can be created and then restored.

If such approach is not suitable for you, you can notice dbForge Studio for MySQL that has such a feature - MySQL Synchronization Tools. See more at http://www.devart.com/dbforge/mysql/stu ... ation.html

[a.alekizoglou]

Thanks for the reply,

After a long research i've look at CopyCAT VCL and I am in the process of evaluating the solution.

[AndreyZ]

It is good to see that you have found a solution.