比較和同步MySQL和MariaDB數據

dbForge Data Compare for MySQL用于比較和同步MySQL，Percona和MariaDB數據庫中的數據。 該工具可清晰顯示數據之間的差異，允許分析數據，生成同步腳本，并一目了然地應用更改。 它還允許使用命令行調度常規MySQL數據比較。

主要功能

• 比較MySQL數據庫中的數據以檢測更改

• 分析兩個數據庫之間的數據差異

• 同步兩個不同步的數據庫

• 以Excel和HTML格式生成數據比較報告

• 生成SQL腳本以更新一個數據庫中的數據以匹配另一個數據庫

• 減少因數據復制錯誤導致的系統停機時間

• 快速部署數據更改，加速應用程序開發

• 為在MySQL標準版上運行的數據庫啟用數據同步

• 以低成本構建自定義數據同步方案

• 將查找數據從開發數據庫復制到生產

Main advantages of Data Compare

Custom mapping of tables, columns, and views

You can manually map tables, their columns, and views, which can't be mapped automatically. This is helpful when you want to compare the following:

• Identical tables or views with different names
• Identical columns with different names

Convenient comparison wizard

The comparison wizard helps you quickly select databases, include required objects in comparison, and start the comparison. Also you can set up additional options.

Following the wizard pages is convenient and guarantees accurate data comparison.

Full control of data synchronization

Data Compare generates the synchronization script, which you can either execute against the Target database, or save to a file, or open in SQL editor.

Integrated SQL editor

Using SQL editor, you can view, edit, and execute synchronization scripts or create and execute queries. 

Data window offers a wide number of options for managing retrieved data. For example, you can use card and grid modes for better view; group, sort, and filter data in the grid; benefit from the cached updates option and more.