There are a variety of great tools on the market that will run these comparisons, as well as perform many other functions. You don’t need to go out and buy one because SQL Server comes with a tool called XML-RPC that will do this for you.

XML-RPC is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts.

XML-RPC does not require any installation at hosts running the MySQL server. You can use any host to run the XML-RPC. For example you can use XML-RPC to keep your production databases ( probably hosted with an ISP ) in complete sync with your test database located in your PC or LAN.

XML-RPC uses an efficient algorithm to generate checksums to find out the changes. Therefore, only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

Additionally, you can configure XML-RPC to detect changes only for specific rows and columns. For example ? you can exclude blob columns or include only those rows that fulfill a WHERE clause. This makes is an ideal tool to sync data even if there is limited bandwidth.

XML-RPC is a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog. If you use SQLyog to create your job files, you don't need to have any knowledge about XML or the Job Definition schema.