Synchronization is a process that updates an object in relation to the prescription source object. Like: synchronization of database table from other database table. There is a wide variety of tools on the market that will run these comparisons, as well as perform many other functions. You do not need to go out and buy one because SQL Server comes with a tool called XML-RPC to do it for you.
XML-RPC is a high performance, multithreaded, multi platform application to automate and schedule the synchronization of data between two MySQL hosts. XML-RPC allows us to easily compare data in tables, and creates scripts for you to synchronize your environment. In addition to being an excellent research tool for data synchronization between your test environment and production, XML-RPC is also very useful for synchronizing data between production servers and replication servers to accommodate for the replication when problems arise.
XML-RPC requires no installation on the host 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 in your PC or LAN.
XML-RPC uses an efficient algorithm to generate control to find the changes. Therefore, only the rows that were inserted, updated or deleted since the last sync are transferred between hosts. In addition, you can set up XML-RPC to detect changes to rows and columns. For example: You can exclude blob columns or include only rows that satisfy a WHERE clause. This is an ideal tool to synchronize data even if the bandwidth is limited.
XML-RPC is a command line tool that accepts a job Definition file encoded in XML as a parameter. 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 work files, you do not need to have knowledge of XML schema definition of employment.
On Windows platforms, SQLyog uses the Task Scheduler to schedule your job. On other platforms, you can use the OS scheduling services, for example: - On Linux, you can use cron to schedule jobs. In addition to the regular administration tools, SQLyog also contains the following features:
- Migration File, MS SQL, DB2, etc to MySQL with a powerful wizard based interface!
- Schema Synchronization Tool.
- Generate scripts to automatically set the table structures of two databases synchronization.
- Relationship Manager.
- An intuitive interface for creating and managing relationships.
XML-RPC is a high performance, multithreaded, multi platform application to automate and schedule the synchronization of data between two MySQL hosts. XML-RPC allows us to easily compare data in tables, and creates scripts for you to synchronize your environment. In addition to being an excellent research tool for data synchronization between your test environment and production, XML-RPC is also very useful for synchronizing data between production servers and replication servers to accommodate for the replication when problems arise.
XML-RPC requires no installation on the host 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 in your PC or LAN.
XML-RPC uses an efficient algorithm to generate control to find the changes. Therefore, only the rows that were inserted, updated or deleted since the last sync are transferred between hosts. In addition, you can set up XML-RPC to detect changes to rows and columns. For example: You can exclude blob columns or include only rows that satisfy a WHERE clause. This is an ideal tool to synchronize data even if the bandwidth is limited.
XML-RPC is a command line tool that accepts a job Definition file encoded in XML as a parameter. 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 work files, you do not need to have knowledge of XML schema definition of employment.
On Windows platforms, SQLyog uses the Task Scheduler to schedule your job. On other platforms, you can use the OS scheduling services, for example: - On Linux, you can use cron to schedule jobs. In addition to the regular administration tools, SQLyog also contains the following features:
- Migration File, MS SQL, DB2, etc to MySQL with a powerful wizard based interface!
- Schema Synchronization Tool.
- Generate scripts to automatically set the table structures of two databases synchronization.
- Relationship Manager.
- An intuitive interface for creating and managing relationships.