What’s New in dbForge Studio for MySQL, v9.0

Last modified: September 25, 2024

Find invalid objects

• This brand new feature allows searing through a database schemas for invalid objects that require recompilation.

Support for new objects

dbForge Studio for MySQL allows working with the following objects established in MariaDB 10.3:

• Packages
• Sequences

Connectivity Improvements

• Connectivity support for MariaDB 10.5

• The Property window now displays Server type for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud.

• The Connections section of the System window displays Server Type for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud.
• The Database Connection Properties and Test Connection windows have been completely redesigned .

SQL Document Improvements

• The –nowarn and –endnowarn tags have been added to the Execution warnings functionality.

• An option to export SQL Query History in the CSV file format has been added.

Code Completion Improvements

• Code completion is now available even in the body of trigger and events.

Data Editor Improvements

• Cached Updates mode

Schema Compare Improvements

• Scripts Folder comparison.
• Object Filter.
• Redesigned Schema Comparison Report window.
• HTML reports got a new smooth design and became more informative and now include actual script differences.
• Ignore DEFINER and SQL SECURITY clauses option has been modified and was split into two options. Now, the is a separate Ignore DEFINER clauses option and the Ignore SQL SECURITY clauses option.
• New Ignore row format table option.
• New Ignore AUTO_INCREMENT option.

  Data Compare Improvements

• Scripts Folder comparison.

• Redesigned Data Compare control.
• Redesigned Data Comparison Report window.
• An option to add a timestamp to the name of the data synchronization script file has been added to Data Synchronization Wizard.
• An option to set default values has been added to Data Synchronization Wizard to sync a NULL source column and a NOT NULL target column.

Database Backup Improvements

• An option to disable reference tables from the backup has been added. Since the reference data is hardly modified or updated, they do nor require backup as often as the rest database objects.

Data Export and Import Improvements

• New Output tab has been added to Data Import Wizard and Data Export Wizard to specify the path to a generated file with data.

• The Options window has been expanded with the Data Export, CSV tab to set default delimiter options for the CSV file format.

• All tabs of Data Export Wizard now show a data export format selected.

Other Improvements

• Command line prompt has been expanded with a full list of available exit codes.

• Activation of dbForge Studio for MySQL can now be done via the command-line interface.