Windows Firewall Control

What's new in this version:

dbForge Studio for MySQL Professional 9.0.391
Improvements:
- The disable animations option was implemented

Fixed:
- Incorrect foreign keys comparison in case of cross-database reference (T313064)
- Add 'lateral' as a reserved keyword (T311236)
- Error on an attempt to read the non-existing column from the metadata for SYSTEM VERSIONING tables in MariaDB (T313844, T314778, T314779)
- Error on processing variables with the same name in different scopes (T314318, T314318, T315270)
- Add schema comparison option to ignore triggers on the target (T314479)
- Incorrect precision of the TINYINT data type in schema synchronization script (T314157)
- Remove inconsistent escaping chars from columns expressions (T310136)
- Incorrect quotes of DEFAULT values (T313524)
- Save user formatting for procedures and functions parameters
- Incorrect decimal separator in Data Editor (T313296, T315422)
- Error on copying table data with virtual columns
- Incorrect data formatting in Data Editor (T310401)
- Incorrect shift of visible zone in Database Diagram when drag-and-dropping objects to the container (T312054)
- Parameters applied only to the first query during multiple queries in Data Report (T307560)
- Incorrect formatting of DATETIME in the Formatting options window for Data Editor (T310931)
- Critical error when loading application (T310150)
- Improved Data Editor behavior in the Filter Editor window (T309337)
- Incorrect export of the date format when exporting from the results grid (T313468, T314591)
- Trace information was added to further fix of the issue with exporting to Xls file (T309909)
- Issues when profiling queries (T310496)
- Showing a valid object as invalid in Find Invalid Objects
- Object duplicates error in object search


dbForge Studio for MySQL Professional 9.0.338
Bug fixes:
- Problem with lost connection after 30 sec is fixed
- Problems with cache file are fixed
- Problem with date and time format is fixed
- Problem with loosing DEFINER is fixed


dbForge Studio for MySQL Professional 9.0.304
Connectivity:
- Connectivity support for MariaDB 10.5 is added
- Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
- Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
- Database Connection Properties and Test Connection windows are redesigned
- Connectivity support for SkySQL is added

Database Design:
- The Find Invalid Objects feature is implemented

Support for new objects:
- Working with the Packages and Sequences established in MariaDB 10.3 is supported

SQL Document:
- -- nowarn and -- endnowarn tags have been added to the Execution warnings functionality
- Exporting execution history in the CSV file format is added

Code Completion:
- Code completion is available in the body of triggers and events

Data Editor:
- Cached Updates mode is implemented

Schema Compare:
- Scripts Folder comparison is added
- Object Filter is implemented
- Schema Comparison Report window is redesigned
- HTML reports are redesigned.
- Pre and post script execution during data synchronization
- Ignore DEFINER and SQL SECURITY clauses option is modified
- Ignore row format table option is added
- Ignore AUTO_INCREMENT option is added
- DDL Diff control is redesigned

Data Compare:
- Scripts Folder comparison is added
- Data Compare control is redesigned
- Data Comparison Report window is redesigned
- Pre and post script execution during data synchronization
- Option to append timestamp to the name of the data sync script file is added to Data Synchronization Wizard
- Option to set default values is added to Data Synchronization Wizard

Data Generator:
- Pre and post script execution during data population.

Database Backup:
- Option to disable reference tables from the backup is added

Data Export and Import:
- Output tab is added to Data Import Wizard and Data Export Wizard
- Data Export, CSV tab is added to the Options window
- Display of selected data export format is added to all tabs of Data Export Wizard

Other Improvements:
- Command line prompt is expanded with a full list of available exit codes
- Activation of the tool via the command-line interface is implemented

User-reported bug fixes:
- Problem with precision for Update Timestamp on MariaDB 10.3 is fixed
- Problem with generating CREATE script 'curdate()' with quotes is fixed
- Problem with generating null is fixed
- Problem with error on backup is fixed
- Problem with increment update is fixed
- Problem with displaying multi-line comments is fixed
- Problem with scrolling fields is fixed
- Problem with error exporting .rdb report to DOCX is fixed
- Problem with options editing format is fixed
- Problem with Restore running is fixed
- Problem with "find and replace" window is fixed
- Problem with comparing projects and databases is fixed
- Problem with displaying warnings in Output is fixed
- Problem with displaying property AUTO_INCREMENT is fixed
- Problem with completion list in case of using JOIN is fixed
- Problem with highlighting error is fixed
- Problem with displaying of controls for 4K monitors is fixed
- Problem with generating backup scripts is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.2.23
- Fixed: problem with connection to Azure Database for MySQL is fixed


dbForge Studio for MySQL Professional 8.2.21

Improvements:
- Support for Check Constraints for MySQL

User reported bugs fixed:
- Problem with script generating is fixed
- Problem with incorrect foreign key creating is fixed
- Problem with procedure debugging is fixed
- Problems with data export to Excel is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.1.45

Bugs fixed:
- Problem with "Set Value To Null" is fixed
- Problem with incorrect display of page count is fixed
- Problem with incorrect utc_timestamp quotes is fixed
- Problem with AUTO_INCREMENT property loosing is fixed
- Problem with wrong status message is fixed
- Problem with wrong table rebuild is fixed
- Problem with date format is fixed
- Problem with procedure debugging when lower_case_table_names = 0 is fixed
- Problem with smart data generators list is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.1.22
Connectivity
- Support for MariaDB 10.4

User reported bugs fixed
- "PDF view" mode of Data Viewer issue is fixed
- A comparison of objects names with different case issue is fixed
- "Spatial view" mode of Data Viewer issue is fixed
- Problem in Data Population Wizard is fixed
- Problem in SQL Document is fixed
- Other user reported bugs are fixed