ApexSQL Data Diff for MySQL 2020 has been released
About ApexSQL Data Diff for MySQL 2020: ApexSQL Data Diff for MySQL is a MySQL Server data comparison and synchronization tool that can detect data differences between two MySQL databases and resolves them without any errors. Beside MySQL versions, it also supports Azure Database, Amazon RDS for MySQL and MariaDB. It generates data comparison results, creates automation scripts, and the comparison and synchronization process can be automated and run unattended.
For more information visit ApexSQL Data Diff for MySQL product page
About this release:
Features:
- MySQL Server 5.6 and higher support
- MariaDB Server 10.1 and higher support
- Azure Database for MySQL support
- Azure Database for MariaDB support
- Amazon RDS for MySQL support
- Amazon RDS for MariaDB support
-
Object types to compare:
- Tables
- Views
-
Comparison options:
- Compare floats using maximum precision
- Ignore Blob columns
- Ignore case in table/view names
- Ignore case in text data types
- Ignore computed columns
- Ignore leading and trailing spaces
- Ignore new objects
- Ignore Timestamp columns
- Ignore underscores in table/view names
- Treat empty strings and nulls as equal
-
Synchronization options:
- Script Use for database
- Customizes object mapping
- Filters object types, or specific objects, or specific rows before the comparison
-
Exports comparison results into:
- HTML simple report
- HTML interactive report
- Excel report
- CSV data report
- Examines data differences between compared objects in the Data difference view panel
- Pre-synchronization warnings and actions
-
Output actions:
- Save synchronization script to a file
- Open synchronization script in the Integrated editor for editing prior to execution
- Synchronize now executes the synchronization script directly on a destination database
- Save project as automation script
- Command line interface
-
Plays a sound upon finished operation:
- Comparison
- Synchronization
- Comparison and synchronization
- GUI themes
- High DPI and 4K resolution support
- Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied
- Application telemetry collects anonymous data on the use and performance of application and application component
- ApexSQL Updater configures advanced updating settings of all installed ApexSQL products
See also:
Release notes
Download
September 16, 2020