The Ultimate Guide to High Availability with MariaDB

KS DB Merge Tools for MySQL and MariaDB

You are viewing an old version of this article. View the current version here.

KS DB Merge Tools for MySQL and MariaDB

KS DB Merge Tools for MySQL and MariaDB is an easy to use diff & merge tool for MySQL and MariaDB databases allowing to compare and sync both schema and data. It is a Freemium application - many features are exposed in the Free version (available for commercial use), some extended features are available only in the paid Pro version.

Application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks:

Home tab

tabs-home

It is a starting point to open databases. Shows summary about all database objects. Note that it does not provide information about data/content changes, only about object definitions.

Object list

tabs-object-list

Lists all objects of some particular type - tables, views, etc. Allows to identify whether some object is new, changed or unchanged (note that for tables and views it does not provide information about data/content changes, only about object definitions). Quick filters available to show only new/changed/new+changed objects. Here we can select required objects on one side and generate synchronization script to merge these changes to the other side.

Table data diff

tabs-data-diff

Compares data for particular table or view. Quick filters available to show only new/changed/new+changed rows. We can select required rows on one side and generate synchronization script to merge these changes to the other side

Text diff

tabs-text-diff

Compares definition of some particular database programming object like view or stored procedure.

Table structure diff

tabs-table-structure-diff

Compares definition of particular table. Here we can select required changes and generate synchronization script for them. This tab is available only in the Pro version, the Free version is using Text diff tab to compare table definitions.

Batch data diff

tabs-batch-data-diff

Allows to compare data for multiple tables and views, providing summary of data changes for the whole database

Query resultl diff

tabs-query-result-diff

Compares arbitrary query results, it can be the same query running on both databases or different queries running on the same or different databases

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.