Best solution to sync two tables

zrinyi

Hi,
what is the best way to sync two tables (call it local and remote)?
I would like a solution that replaces a registry if the local is different of the remote one. And insert the registry if it doesn't exist on the local table.
Is there any smart solution for this?
Thank you in advance!
István

kklosson

I would consider doing this with an external tool. For example, Navicat has a synchro capability and I image other tools such as MySQL Workbench do as well.

zrinyi

Hi kklosson,
thank you for the suggestion!
I will check MySQL Workbench possibilities.
Regards, Istvan