Devart dbForge Studio for MySQL Enterprise v10.0.46
Devart dbForge Studio for MySQL Enterprise v10.0.46
dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more.
In addition, dbForge Studio for MySQL is a perfect alternative to MySQL Workbench. Check out the pros of our tool over MySQL Workbench!
Database Development
Building, editing, and running queries, as well as measuring and optimizing query performance get much simpler with the following functionality:
MySQL Code Completion
SQL code formatting
SQL syntax check
MySQL Debugger
Query Profiler
Database Design
Database design tools allow users to create a database diagram, objects, projects, as well as to compare and synchronize database schemas efficiently and in a user-friendly interface.
Visual query builder
Visual design and editing
Database project framework
Table Designer
Database Administration
With these features, users can manage their accounts, set up permissions, monitor open sessions and their activity, as well as perform table maintenance. In addition, it is possible to back up and restore databases to/from a backup file.
Backup and Restore
Service Control
Data Export and Import
Security Manager
Copy Database
Data Reports and Analysis
Creation of data reports and pivot tables, as well as data comparison and synchronization may take much time and efforts while your work can be more productive using the following features:
Data Report Wizard
Report Designer
Pivot Tables
Chart Designer
Command line support
Broad Compatibility Options
dbForge Studio for MySQL is compatible with:
All MySQL server versions
All MariaDB server versions
Percona PAM Authentication for MySQL
Sphinx Search Engine
...and more!
Intelligent SQL Coding
Intelligent code completion, formatting, MySQL prompt, and code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly.
Database Compare and Sync
When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:
Compare and sync data and schemas
Schedule regular database sync tasks
Generate comparison report
Data Generator
Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.
Documenter
A tool for generation of MySQL and MariaDB database documentation. Documenter allows you to:
Retrieve an overview of the database structure
View inter-object and inter-database dependencies
Customize documentation with style templates
Generate documentation files in the HTML, PDF and Markdown formats
Visual Query Builder
Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.
Database Designer
Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:
Viewing foreign key relations
Displaying DB objects with properties
Execution of stored routines
Import/Export Data
Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available.
Database Backup
Dump databases in SQL format and schedule regular MySQL database backups. Use 5 levels of file compression and wide set of options to fine-tune backups. Save your settings and connections as a project for the next time or to use in the command line.
Database Administration
Tools for MySQL database administration and management include means for:
Managing user privileges
MySQL service control
Managing server variables
Table maintenance
Managing server sessions
MySQL Debugger
The first debugger for MySQL that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution.
Table Designer
Visual designer for modifying or creating table structure, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based on the name you enter.
Database Refactoring
Improve MySQL database design by applying small changes. When such changes are performed, they are fully transparent and application takes care of all dependencies in the database:
Renaming database objects with preview
Refactoring script
Query Profiler
Improve multi-second queries using Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:
Offers visual query profiling
Compares profiling results
Report and Analysis
Data reporting is performed using wizard with rich feature set, manually, or via command line. Ready reports can be imported to 9 formats and delivered to their recipients.
Group and summarize your data in pivot tables to make it easier to read and understand.
Database Projects
The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.
Copy Database
Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:
Customize copying settings
Copy databases together with data
Drop a database if it already exists on a target server
10.0.46 03-Nov-23
New feature
Source Control
Code Completion & Syntax Check
Added highlighting and quick navigation between syntax pairs
Navigation between COLUMNS and VALUES in INSERT statements has been made easier, also augmented with highlighting
Improved the behavior of highlighting within INSERT statements in case of mismatches in VALUES
Implemented support for the JSON_TABLE() table function in MariaDB
Supported JSON datatype parameters in stored procedures and functions
Improved commenting out selections inside a line of code
Supported expressions when creating indexes
Supported ASC | DESC for indexes with functional key parts
Added a new snippet ssf in addition to sel
Supported an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements
Supported FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME in CREATE USER statements
Supported ENCRYPTION in CREATE TABLESPACE and ALTER TABLESPACE statements
Added support for UNDO TABLESPACE statements
Supported AUTOEXTEND_SIZE in CREATE/ALTER TABLE and CREATE/ALTER TABLESPACE statements
Added IDENTIFIED BY RANDOM PASSWORD to CREATE USER and ALTER USER statements
Added full support for complex VALUE statements
Improved the behavior of the FOR ... END FOR statement
The CAST() function now supports the AT TIME ZONE operator
Non-aggregated columns are now suggested for GROUP BY statements
The Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar have been replaced with a single button Reset Suggestions
Database Design
Added support to easily duplicate database objects and migrate them to a different server and added an option to drop the destination object
All tables, views, and containers on database diagrams are now semitransparent, and all the interrelations are perfectly visible
Added a few skins for diagrams and improved the zooming behavior
Implemented the Clear Waypoints option that eliminates all the waypoints created for a specific relation. The relation gets restructured and shown in its default condition
Schema Compare
Supported Source Control as the Source Type and Target Type in the comparison wizard, specify the required repository, and compare different revisions
Added an option to enable/disable the display of DDL differences for pairs of compared objects with the Equal status
Introduced a new group of comparison options called Sequences, which includes Ignore CACHE, Ignore CYCLE, Ignore INCREMENT BY, Ignore MAXVALUE, Ignore MINVALUE, and Ignore START
Improved the behavior of the Ignore Permissions option
Added a new exit code 114 for invalid object filters
The object description process now ignores folders with static data, which may contain large files and thus may affect the performance
Supported saving the .scomp comparison document directly from the comparison wizard
Data Compare
Added support to hide empty columns from the grid that displays data differences
In case there are NULL to NOT NULL mapped pairs, the synchronization wizard introduces a new page called Issues where you can specify the conflict resolution behavior for potential sync issues
Added the Ignore internal spaces option that allows comparing string data types while ignoring whitespaces located in the middle of a line
Added support to save the .dcomp comparison document directly from the comparison wizard
Find Invalid Objects
Added support to search for invalid objects across all databases on the entire server
The search for invalid objects can now be launched from the command line
Security Manager
Added a checkbox that allows you to quickly lock and unlock user accounts
Connectivity
Supported the latest version of the Transport Layer Security cryptographic protocol - v1.3
General Features
Added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time
Extended support the INET6 data type, intended for the storage of IPv6 addresses
Added support for spatial reference identifiers (SRID)
Introduced an option that enables the quoting of identifiers during script generation
Added an option that clears existing folders from the command line
Upgraded the Retrieve Data feature and renamed it to Select Top Rows
Now Query Profiler displays the entire information tooltip when you place the cursor over an SQL statement
Tweaked the Do not highlight less than option for Query Profiler
Reworked the option filtering algorithm that is applied when editing formatting profiles
Supported an option to add IF NOT EXISTS to CREATE statements in your deployment scripts
Tweaked the display of filtered data in the Card View mode
The Search Options algorithm in Options has been substantially improved
Added the Insert new tabs to the right of existing tabs option on the Tabs and Windows tab in Options
The Tabs and Windows tab has also been expanded with the Tabs Layout, Show tabs in multiple rows, and Close tabs with middle-click options
Added the Include size of the Integer datatype in statements option, which enables/disables the display of the size of integer values in generated DDL statements
Introduced an option to include named regions in all CRUD templates
Improved the behavior of the /restore /treatwarningaserror command
The Data Pump section of the Studio's Start Page now includes the Copy Databases feature
To keep it consistent across our tools, Execution History has been renamed to Query History
For additional convenience, the Studio now keeps the user-defined layout of columns in Query History
The application launch time is now displayed in the Output pane alongside the application launch timestamp
The Standard edition can be activated and deactivated from the command line using the /activate and /deactivate commands
SSL/SSH connections are now available in the free Express edition of the Studio
User-reported and internal bug fixes
Resolved an issue with invoking the popup menu on macOS (D124053)
Improved the application startup time (D133835)
Fixed an issue with processing long strings in the SQL Editor (D129624)
Resolved an application activation error (D134819)
Improved the performance of Query Builder (D105655)
Improved data display for the JSON_OBJECT function (T260249)
Fixed an error that occurred when working with relationships on the diagram (D63905)
Resolved an issue that occurred when establishing an SSH connection to the server (T262258)
The 'Retrieve Data' command has been renamed to 'Select All Rows' and its behavior has been improved (D76206)
The database server error text now includes the error code (D93810)
Improved the data editing behavior for tables with INVISIBLE columns in Data Editor (p214425, p214092, p57189)
Fixed a memory leak issue that occurred during debugging of a procedure with numerous SELECT statements (D77368)
Fixed an issue with incorrect comments for table partitions (T304320)
Fixed a Pivot Table error that occurred when closing the application (T314642)
Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor (T319897)
Fixed the 'Illegal mix of collations' error that occurred when retrieving metadata from the database server (T316238, D72129, p24670)
Fixed an error that occurred when editing data in Data Editor (T312352)
Improved the display of the date and time format in the Output window (T312234)
Fixed an error that occurred when opening a data connection in SQL Document (D53752, D64944)
Significantly improved the behavior of connection management and fixed an error that occurred when prompting for a connection password (D61622)
Fixed an error that occurred when reading data from Excel files during import (D127368)
Fixed an error that occurred when editing INSERT .. VALUES expressions in Query Builder (D127845)
Improved the behavior of Schema Compare to alert users with an error message when duplicate indexes exist in project tables (D127487)
Fixed an error that occurred when editing a script in SQL document (D82595)
Fixed the issue with indentation that occurred when formatting BEGIN...END code blocks (P177937)
Fixed an error that occurred when closing the Studio with incomplete operations in open documents (T324608, T310517)
Improved the visualization of table relationships in Query Builder involving functions in JOIN conditions (D62017)
Fixed an error that occurred during the generation of a synchronization script when connected to AWS RDS for MySQL (D129532)
Added support for COLLATE for user-defined functions of return type (D97571)
New feature
Source Control
Code Completion & Syntax Check
Added highlighting and quick navigation between syntax pairs
Navigation between COLUMNS and VALUES in INSERT statements has been made easier, also augmented with highlighting
Improved the behavior of highlighting within INSERT statements in case of mismatches in VALUES
Implemented support for the JSON_TABLE() table function in MariaDB
Supported JSON datatype parameters in stored procedures and functions
Improved commenting out selections inside a line of code
Supported expressions when creating indexes
Supported ASC | DESC for indexes with functional key parts
Added a new snippet ssf in addition to sel
Supported an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements
Supported FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME in CREATE USER statements
Supported ENCRYPTION in CREATE TABLESPACE and ALTER TABLESPACE statements
Added support for UNDO TABLESPACE statements
Supported AUTOEXTEND_SIZE in CREATE/ALTER TABLE and CREATE/ALTER TABLESPACE statements
Added IDENTIFIED BY RANDOM PASSWORD to CREATE USER and ALTER USER statements
Added full support for complex VALUE statements
Improved the behavior of the FOR ... END FOR statement
The CAST() function now supports the AT TIME ZONE operator
Non-aggregated columns are now suggested for GROUP BY statements
The Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar have been replaced with a single button Reset Suggestions
Database Design
Added support to easily duplicate database objects and migrate them to a different server and added an option to drop the destination object
All tables, views, and containers on database diagrams are now semitransparent, and all the interrelations are perfectly visible
Added a few skins for diagrams and improved the zooming behavior
Implemented the Clear Waypoints option that eliminates all the waypoints created for a specific relation. The relation gets restructured and shown in its default condition
Schema Compare
Supported Source Control as the Source Type and Target Type in the comparison wizard, specify the required repository, and compare different revisions
Added an option to enable/disable the display of DDL differences for pairs of compared objects with the Equal status
Introduced a new group of comparison options called Sequences, which includes Ignore CACHE, Ignore CYCLE, Ignore INCREMENT BY, Ignore MAXVALUE, Ignore MINVALUE, and Ignore START
Improved the behavior of the Ignore Permissions option
Added a new exit code 114 for invalid object filters
The object description process now ignores folders with static data, which may contain large files and thus may affect the performance
Supported saving the .scomp comparison document directly from the comparison wizard
Data Compare
Added support to hide empty columns from the grid that displays data differences
In case there are NULL to NOT NULL mapped pairs, the synchronization wizard introduces a new page called Issues where you can specify the conflict resolution behavior for potential sync issues
Added the Ignore internal spaces option that allows comparing string data types while ignoring whitespaces located in the middle of a line
Added support to save the .dcomp comparison document directly from the comparison wizard
Find Invalid Objects
Added support to search for invalid objects across all databases on the entire server
The search for invalid objects can now be launched from the command line
Security Manager
Added a checkbox that allows you to quickly lock and unlock user accounts
Connectivity
Supported the latest version of the Transport Layer Security cryptographic protocol - v1.3
General Features
Added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time
Extended support the INET6 data type, intended for the storage of IPv6 addresses
Added support for spatial reference identifiers (SRID)
Introduced an option that enables the quoting of identifiers during script generation
Added an option that clears existing folders from the command line
Upgraded the Retrieve Data feature and renamed it to Select Top Rows
Now Query Profiler displays the entire information tooltip when you place the cursor over an SQL statement
Tweaked the Do not highlight less than option for Query Profiler
Reworked the option filtering algorithm that is applied when editing formatting profiles
Supported an option to add IF NOT EXISTS to CREATE statements in your deployment scripts
Tweaked the display of filtered data in the Card View mode
The Search Options algorithm in Options has been substantially improved
Added the Insert new tabs to the right of existing tabs option on the Tabs and Windows tab in Options
The Tabs and Windows tab has also been expanded with the Tabs Layout, Show tabs in multiple rows, and Close tabs with middle-click options
Added the Include size of the Integer datatype in statements option, which enables/disables the display of the size of integer values in generated DDL statements
Introduced an option to include named regions in all CRUD templates
Improved the behavior of the /restore /treatwarningaserror command
The Data Pump section of the Studio's Start Page now includes the Copy Databases feature
To keep it consistent across our tools, Execution History has been renamed to Query History
For additional convenience, the Studio now keeps the user-defined layout of columns in Query History
The application launch time is now displayed in the Output pane alongside the application launch timestamp
The Standard edition can be activated and deactivated from the command line using the /activate and /deactivate commands
SSL/SSH connections are now available in the free Express edition of the Studio
User-reported and internal bug fixes
Resolved an issue with invoking the popup menu on macOS (D124053)
Improved the application startup time (D133835)
Fixed an issue with processing long strings in the SQL Editor (D129624)
Resolved an application activation error (D134819)
Improved the performance of Query Builder (D105655)
Improved data display for the JSON_OBJECT function (T260249)
Fixed an error that occurred when working with relationships on the diagram (D63905)
Resolved an issue that occurred when establishing an SSH connection to the server (T262258)
The 'Retrieve Data' command has been renamed to 'Select All Rows' and its behavior has been improved (D76206)
The database server error text now includes the error code (D93810)
Improved the data editing behavior for tables with INVISIBLE columns in Data Editor (p214425, p214092, p57189)
Fixed a memory leak issue that occurred during debugging of a procedure with numerous SELECT statements (D77368)
Fixed an issue with incorrect comments for table partitions (T304320)
Fixed a Pivot Table error that occurred when closing the application (T314642)
Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor (T319897)
Fixed the 'Illegal mix of collations' error that occurred when retrieving metadata from the database server (T316238, D72129, p24670)
Fixed an error that occurred when editing data in Data Editor (T312352)
Improved the display of the date and time format in the Output window (T312234)
Fixed an error that occurred when opening a data connection in SQL Document (D53752, D64944)
Significantly improved the behavior of connection management and fixed an error that occurred when prompting for a connection password (D61622)
Fixed an error that occurred when reading data from Excel files during import (D127368)
Fixed an error that occurred when editing INSERT .. VALUES expressions in Query Builder (D127845)
Improved the behavior of Schema Compare to alert users with an error message when duplicate indexes exist in project tables (D127487)
Fixed an error that occurred when editing a script in SQL document (D82595)
Fixed the issue with indentation that occurred when formatting BEGIN...END code blocks (P177937)
Fixed an error that occurred when closing the Studio with incomplete operations in open documents (T324608, T310517)
Improved the visualization of table relationships in Query Builder involving functions in JOIN conditions (D62017)
Fixed an error that occurred during the generation of a synchronization script when connected to AWS RDS for MySQL (D129532)
Added support for COLLATE for user-defined functions of return type (D97571)
Only for V.I.P
Warning! You are not allowed to view this text.