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

Last modified: September 25, 2024

Support for MySQL server 5.5

Our product is fully compatible with MySQL server version 5.5

• New features were added and obsolete clauses removed in the Syntax check functionality
• New encodings were added to the encoding list in the Connection Properties dialog
• New kinds of partitioning are supported in the table editor

Master-Detail Browser

Explore and analyze master-detail data in a convenient browser with the following features:

• Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
• Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
• The document allows saving and loading data and diagram for future use
• Sorting and filtering data in the Data view
• Ability to analyze self-referencing tables

Object dependency tree - unique feature

Easily explore object’s references and dependants in Database Explorer. Compilation of dependants for debugging is now also available through the object’s shortcut menu.

Enhanced Data Editor

Newly added features and a few totally redesigned ones provide even more freedom when working with data.

• Foreign Key lookup editor added
• Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
• Few indications added to inform user about Data Editor’s state
• Editing of tables in join statements is enabled now
• Option for numbering records added
• Copy data with header functionality added
• Ability to build graphical representation of your data with fully functional wizard added

Improved Security Manager

• Ability to edit permissions for several users added
• Virtual roles for users were added to allow granting a definite set of permissions to selected users
• Grouping by hosts in the users list tree added
• Editing users and working with Security Manager window simplified

Data Export and Import improvements

• Ability to export data from several tables at once added
• Exporting data from command line added
• Importing data from command line added

Object Viewer - a simple way to view object’s details

Object Viewer (formerly known as Summary Window) was totally redesigned to provide an easier way for analyzing objects and their structure:

• There are three views to display properties, DDL (text), and data of the selected object
• Inner navigation through object hierarchy
• History with previously viewed objects
• More information about each object is displayed in the Properties view now

Brand new start page

New functional start page providing the easiest way to learn the product’s features and to run the most frequently used ones added.

New state-of-the-art skins

Four new UI skins added to improve the application appearance.

Other improvements

• Ability to view internal SQL queries that are sent to the server with parameter’s values added
• Few UI improvements in Database Explorer were made
• Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
• Highlighting of differences on comparing SQL profiling results added
• More informative progress during Schema and Data comparison