比較和同步MySQL和MariaDB數(shù)據(jù)

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

主要功能

• 比較MySQL數(shù)據(jù)庫中的數(shù)據(jù)以檢測更改

• 分析兩個數(shù)據(jù)庫之間的數(shù)據(jù)差異

• 同步兩個不同步的數(shù)據(jù)庫

• 以Excel和HTML格式生成數(shù)據(jù)比較報告

• 生成SQL腳本以更新一個數(shù)據(jù)庫中的數(shù)據(jù)以匹配另一個數(shù)據(jù)庫

• 減少因數(shù)據(jù)復制錯誤導致的系統(tǒng)停機時間

• 快速部署數(shù)據(jù)更改，加速應用程序開發(fā)

• 為在MySQL標準版上運行的數(shù)據(jù)庫啟用數(shù)據(jù)同步

• 以低成本構建自定義數(shù)據(jù)同步方案

• 將查找數(shù)據(jù)從開發(fā)數(shù)據(jù)庫復制到生產

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.