What is KS DB Merge Tools for MySQL?
KS DB Merge Tools for MySQL is a diff and merge GUI tool for MySQL and MariaDB databases. This tool can be used to compare and sync both schema and data changes.
The application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. The starting point is the Home tab - it is used to open databases and show summary about database schema and programming objects changes: table definitions, views, stored procedures and so on. From here, users can drill-down details hidden by these summary numbers - compare lists of objects, definition of particular object or even line of code.
By opening a list of table definitions or views, data can be compared for a given table or view. Tables are compared by primary key, and for views the user can define a unique comparison key. Using the Batch data diff tool, the data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Query result diff tool provides the way to compare any arbitrary query result, it can be a SELECT statement or a stored procedure call. This tool also can be used to set up column mapping, configure key columns and ignore some columns if necessary.
KS DB Merge Tools for MySQL is a Freemium application - basic features are exposed in the Free version which is available for commercial use.
The application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. The starting point is the Home tab - it is used to open databases and show summary about database schema and programming objects changes: table definitions, views, stored procedures and so on. From here, users can drill-down details hidden by these summary numbers - compare lists of objects, definition of particular object or even line of code.
By opening a list of table definitions or views, data can be compared for a given table or view. Tables are compared by primary key, and for views the user can define a unique comparison key. Using the Batch data diff tool, the data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Query result diff tool provides the way to compare any arbitrary query result, it can be a SELECT statement or a stored procedure call. This tool also can be used to set up column mapping, configure key columns and ignore some columns if necessary.
Many tabs provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.
Application has a command line tool, designed to automate
generation of diff reports and synchronization scripts and can run on
Windows and Linux.
KS DB Merge Tools for MySQL is a Freemium application - basic features are exposed in the Free version which is available for commercial use.
Categories & Use Cases
Media
1 / 8
