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

Source Control (available in the Enterprise edition only)

Added support for Azure DevOps Server, Apache Subversion (SVN), TFVC, Git (including GitHub, GitLab, and Bitbucket), Mercurial (Hg), Perforce (P4), SourceGear Vault, and working folders
Implemented version control of database schemas and static table data
Implemented two development models for version control management: dedicated and shared
Implemented mechanisms that enable the following actions for database version control:
- Making, viewing, committing, and reverting changes in databases with dependencies
- Getting remote changes to a local database copy
- Reviewing and resolving conflicts
- Running quick comparisons of database versions
Implemented the history of changes

Code Completion & Syntax Check

Added highlighting and quick navigation between syntax pairs
Enhanced navigation between COLUMNS and VALUES in INSERT statements
Improved behavior of highlighting within INSERT statements in case of mismatches in VALUES
Added support for the JSON_TABLE() table function in MariaDB
Added support for JSON datatype parameters in stored procedures and functions
Added the ability to comment out selections inside a line of code
Added the ability to apply expressions when creating indexes
Added the ability to use ASC | DESC for indexes with functional key parts
Added a new snippet ssf in addition to sel
Added the ability to assign columns an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements
Introduced FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME in CREATE USER statements
Enabled ENCRYPTION in CREATE TABLESPACE and ALTER TABLESPACE statements
Added support for UNDO TABLESPACE statements
Introduced AUTOEXTEND_SIZE in CREATE/ALTER TABLE and CREATE/ALTER TABLESPACE statements
Added the ability to include IDENTIFIED BY RANDOM PASSWORD in CREATE USER and ALTER USER statements
Added full support for complex VALUE statements
Improved the behavior of the FOR … END FOR statement
Added support for the AT TIME ZONE operator in the CAST() function
Added suggestion for non-aggregated columns in GROUP BY statements
Replaced the Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar with a single Reset Suggestions button

Database Design

Added the ability to duplicate database objects and migrate them to a different server
Added an option to drop the destination object
Made all tables, views, and containers on database diagrams semitransparent; all the interrelations are visible
Added a few skins for diagrams
Improved the zooming behavior
Implemented the Clear Waypoints option that eliminates all the waypoints created for a specific relation

Schema Compare

Added Source Control as the Source Type and Target Type in the comparison wizard
Added the ability to turn on/off 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
Improved the object description process; now it ignores folders with static data
Added the ability to save the .scomp comparison document directly from the comparison wizard

Data Compare

Added the ability to hide empty columns from the grid that displays data differences
Implemented a new page called Issues if there are NULL → NOT NULL mapped pairs. On the Issues page, the conflict resolution behavior for potential sync issues can be specified
Added the Ignore internal spaces option
Added the ability to save the .dcomp comparison document directly from the comparison wizard

Find Invalid Objects

Added the Check All and Uncheck All options to the Databases tree to search for invalid objects across all databases on the entire server
Implemented the search for invalid objects from the command line

Security Manager

Added a checkbox to quickly lock and unlock user accounts

Connectivity

Supported the latest version of the Transport Layer Security cryptographic protocol – v1.3

General Features

Added full support for temporal tables in MariaDB
Added extended support for the INET6 data type and spatial reference identifiers (SRID)
Introduced an option that turns on 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
Updated the behavior of Query Profiler. 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
Added an option to include IF NOT EXISTS to CREATE statements in your deployment scripts
Tweaked the display of filtered data in the Card View mode
Improved the Search Options algorithm in Options
Added the Insert new tabs to the right of existing tabs option on the Tabs and Windows tab in Options
Expanded the Tabs and Windows tab 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 in Options
Introduced an option to include named regions in all CRUD templates
Improved the behavior of the /restore /treatwarningaserror command
Added the Copy Databases feature to the Data Pump section of the Studio’s Start Page
Renamed Execution History to Query History
Added the user-defined layout of columns to Query History
Implemented the display of the application launch time in the Output pane alongside the application launch timestamp
Added the ability to activate and deactivate the Standard edition from the command line using the /activate and /deactivate commands
Introduced SSL/SSH connections in the free Express edition of the Studio