What’s New in dbForge Studio for MySQL, v7.4

SQL Document

• New Transaction Reminder implemented

• New Execution notifications implemented
• Color effect of the current line

Code Completion

• Code folding for BEGIN ... END for IF

• Prompting Percona Server variables (CL, QI and Parameter Info)
• Prompting MySQL Server variables
• Prompting variables for MariaDB Server
• Prompting Optimizer Hints
• Prompting Geographic Functions
• Prompting Extended JSON Functions
• Prompting values for TABLE_TYPE
• Prompting Multiple-Clustering-Indexes for TokuDB Engine
• Prompting Cast(... AS JSON)
• Prompting CHANGE MASTER TO
• Prompting CHANGE REPLICATION FILTER
• Prompting ALTER INSTANCE
• Prompting CONNECT Zipped File Tables
• Prompting ALTER USER CURRENT_USER
• Prompting SHOW CREATE USER
• Prompting RESET MASTER
• Prompting CREATE [OR REPLACE] ... [IF NOT EXISTS]
• Prompting Spatial Reference systems
• Prompting Compound statements outside of stored programs
• Prompting SET DEFAULT ROLE ... FOR
• Prompting VIR virtual table type for CONNECT engine
• Prompting SET ROLE
• Prompting CONNECT engine
• Prompting SPIDER ENGINE
• Prompting START TRANSACTION
• Prompting RELEASE_ALL_LOCKS() and ANY_VALUE()
• Prompting CREATE TABLE
• Prompting Ngram and mecab Full-Text Parser

Query Builder

• New aggregates functions added

• Design of WHERE clause improved

Data Viewer

• Spatial Viewer improved

• Data Types in the Data Editor column headers corrected

Data Export and Import

• Export to Google Sheets and Import from Google Sheets implemented

• Data Export to SQL with Bulk option added

Schema Compare

• New Schema Comparison and Synchronization Engine implemented

• Formatting of object DDLs in the Diff view the Schema Comparison document implemented
• New Schema Comparison Options added:

  • 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 constraint names
  • Ignore foreign keys actions ON UPDATE and ON DELETE
  • Ignore indexes
  • Ignore fulltext Indexes
  • Ignore spatial Indexes
  • Ignore index 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
• New comparison and synchronization progress improved

Data Comparison

• New Data Comparison options added:

  • Column synchronization without comparison

  • Data Tolerance comparison

• New Data Synchronization Options added:
• Include USE database name
• Check for the concurrency updates
• Disable check constraints
• New comparison and synchronization progress improved

Data Generator

• New Data Population options added:

  • Include USE database name
  • Disable check constraints

Copy Databases

• Finished Copying Notification implemented

• Command-Line Interface implemented

Other Improvements

• Product Update Manager improved

• Digital signature for the installation file

• Support for SHA256 Authentication when connecting to MySQL