Support for Google Sheets - Now, you can easily migrate table data between your MySQL tables and Google Spreadsheets. All you need to do is to specify the URL/ID of your Google Spreadsheets table, and our handy Data Wizard will do the rest of work for you.
Data Export to SQL with Bulk Insert Option - When exporting data to SQL as the INSERT statement, you can select the USE Bulk Insert option and set the bulk size. The option boosts data export and saves time.
SQL Document
Execution notifications - When query execution is completed, a notification with details such as the name of a document and duration is displayed.
Transaction Reminder - The notification alerts users that a transaction has not been completed if you execute a script. It contains the document name and a number of open transactions.
Сolor effect of Сurrent Сode Line - Now, the currently selected line of code is highlighted with a color effect.
Code Completion - The Code Completion feature has been enriched with the prompting of the following:
Percona Server variables (CL, QI and Parameter Info)
MySQL Server variables
Variables for MariaDB Server
Optimizer Hints
Geographic Functions
Extended JSON Functions
Values for TABLE_TYPE
Multiple-Clustering-Indexes for TokuDB Engine
Cast(… AS JSON)
CHANGE MASTER TO
CHANGE REPLICATION FILTER
ALTER INSTANCE
CONNECT Zipped File Tables
ALTER USER CURRENT_USER
SHOW CREATE USER
RESET MASTER
CREATE [OR REPLACE] … [IF NOT EXISTS]
Spatial Reference systems
Compound statements outside of stored programs
SET DEFAULT ROLE … FOR
VIR virtual table type for CONNECT engine
SET ROLE
CONNECT engine
SPIDER ENGINE
START TRANSACTION
RELEASE_ALL_LOCKS() and ANY_VALUE()
CREATE TABLE
Ngram and mecab Full-Text Parser
Schema and Data Comparison
Improved comparison and synchronization progress - Both schema/data comparison and schema/data synchronization feature a new progress window with the list of processes taking place and specification of time elapsed.
New Schema Comparison and Synchronization Engine - Implemented a brand new schema comparison and synchronization engine. In particular, the new engine resulted in the following changes and improvements:
Comparison of databases with different structures.
A bunch of new comparison and synchronization options.
Handy Diffs view.
Smart Sync.
Formatting of Object Scripts in Diff View - The Text Comparer section of the Schema Comparison document features a new Format Database Object Script button that allows formatting DDLs of the selected source and target objects.
New schema comparison options - The New Schema Comparison wizard includes the following options:
Associate column names having similar name options
Ignore case in objects names
Ignore spaces in objects names
Disable dependency analysis
Ignore collations
Ignore datatypes in column
Ignore permissions
Ignore Triggers
Ignore firing order for triggers
Ignore check constraints
Ignore column order in indexes
Ignore constraints’ names
Ignore foreign keys actions ON UPDATE and ON DELETE
Ignore indexes
Ignore fulltext Indexes
Ignore spatial Indexes
Ignore indexes’ names
Ignore primary keys
Ignore triggers present only in Target
Ignore indexes present only in Target
Ignore comments
Ignore column default values
Ignore NOT NULL constraints
Ignore COMMENT objects
Always Exclude newly added objects
Ignore Partitions
Schema Synchronization Wizard redesigned
New Schema Synchronization Options added:
Include USE database name
Use DROP and CREATE instead of ALTER for tables
Use DROP and CREATE instead of ALTER for views, procedures, functions
Exclude comments
Check For Object Existence
Redesigned Schema Synchronization Wizard - Schema Synchronization Wizard has been completely redesigned to provide more smooth and custom-tailored schema synchronization.
Issues - The Issues page appears only if there are any problems that may affect schema synchronization. The page allows you to easily review and resolve issues.
Summary - With the Summary page, you can look through the complete plan of actions that will take place during synchronization. Also, the page includes the Warnings tab allowing to view warnings on the issues that may affect synchronization.
Data Comparison
Column synchronization without comparison - The Column Mapping dialog box features two new columns - Compare and Sync that allows you to include/exclude columns from comparison and synchronization.
Tolerance interval - This option allows you to specify the difference between the values of a source and target. If it does not exceed the specified value, the values are considered equivalent.
Data Synchronization - Data Synchronization Wizard includes the following new options:
Include USE database name
Check for the concurrency updates
Disable check constraints
Data Generator
New Data Population Options - Data Population Wizard includes the following new options:
Include USE database name
Disable check constraints
Copy Databases
Finished Copying Notification - Alerts users to the result of a database copy. It also contains the number of copied databases and the time spent copying.
Command-Line Interface - Now, dbForge Studio for MySQL allows copying databases through the command-line interface.
Query Builder
Reorganized aggregate functions - The aggregate functions available in the Selection tab of Query Builder have been reorganized to provide the most-used functions first. Also, the design of the WHERE clause has been improved.
Data Viewer
Improved Spatial Viewer - Spatial Viewer features the object type and its coordinates.
Extended Data Types Support - ENUM, GEOMETRY, and UNSIGNED NUMERIC data types are supported in Data Editor column headers.
Other Improvements
Improved Product Update Manager.
Digital signature for the installation file.
Support for SHA256 Authentication when connecting to MySQL.
Support for Google Sheets when exporting and importing data