No one has ever imagined dbForge would do it to Google Sheets!

March 27th, 2018

”Wow!’, ”Cool!’, “Fantastic!”, “A revelation!” – this was the first reaction of our colleagues when we presented fresh dbForge Studio for MySQL, v7.4 to them. Indeed, our team has done a huge work to meet our customers’ needs and expectations. In a bid to fulfill this objective, we have enhanced our renowned MySQL GUI tool with the most timely and essential features, improvements, and updates. And now, we are eager to unveil all these awesome additions to dbForge Studio for MySQL to you. The list turned out to be quite impressive and long, but believe us, it is worth at least looking through. To put the story short, let’s start!

Data Export and Import

Unique Feature: Support for Google Sheets

We are super excited to present a crown-jewel feature of this release, – Support for Google Sheets when exporting and importing data. 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 Export Wizard and Data Import Wizard will do the rest of the work for you!

Data Import between MySQL tables and Google Spreadsheets via dbForge Studio for MySQL

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 hugely boosts data export and saves your time!

INSERT statement with the USE Bulk Insert option

SQL Document

Execution notifications

When query execution is completed, a notification with such details as the name of a document and duration is displayed. In addition, you can enable a notification and specify execution duration on the Notifications tab of the Options menu.

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. On the Options menu, notifications for transaction reminder are selected by default. Additionally, you can set duration on the menu.

Getting notified of the uncommited transactions

Сolor effect of Сurrent Сode Line

Now, the currently selected line of code is highlighted with a color effect.

The current line code is highlighted with color

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

A rich selection of prompts

Also, BEGIN … END construct within IF can be expanded and collapsed.

The possibility to collapse or expand BEGIN … END construct within IF

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.

The new window that indicates the comparison and synchronization progress

New Schema Comparison and Synchronization Engine

We have implemented a brand new schema comparison and synchronization engine to make the Schema Compare feature of dbForge Studio for MySQL yet more useful and flexible. 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.

DDL formatting of compared objects within Text Compare

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

Broad schema comparison options

Redesigned Schema Synchronization Wizard

Schema Synchronization Wizard has been completely redesigned to provide more smooth and custom-tailored schema synchronization. In particular, the wizard includes the following new pages:

Options

The Options page allows to customize schema synchronization with the following options:

  • 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

A list of options that allow you to customize schema synchronization within dbForge Studio for MySQL

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.

The Issues page gives a possibility to either resolve any issues or to ignore them

Summary

With the Summary page, you can look through the complete plan of actions that will take place during synchronization.

The Summary page displays the synchronization actions in the order in which they occur

Also, the page includes the Warnings tab allowing to view warnings on the issues that may affect synchronization.

The Warnings tab within MySQL Studio

Data Comparison

Column synchronization without comparison

The Column Mapping dialog box features two new columns, – Compare and Sync that allows including and excluding columns from comparison and synchronization.

The two new columns Compare and Sync within the Column Mapping dialog box

Tolerance interval

The Options tab of the New Data Comparison wizard includes the Tolerance interval option. The option allows specifying the module of difference between the values of source and target. If it does not exceed the specified value, the values are considered equivalent.

Specify the tolerance interval option

Data Synchronization

Data Synchronization Wizard includes the following new options:

  • Include USE database name
  • Check for the concurrency updates
  • Disable check constraints

The options within Data Synchronization Wizard

Data Generator

New Data Population Options

Data Population Wizard includes the following new options:

  • Include USE database name
  • Disable check constraints

Data population options in dbForge Studio for MySQL

Copy Databases

Finished Copying Notification

The notification alerts users about the result of database copying. It also contains the number of copied databases and the time spent on copying.

A notification received upon the completion of database copying

Command-Line Interface

Now, dbForge Studio for MySQL allows copying databases through the command-line interface.

Copy databases via a command-line interface in dbForge Studio for MySQL

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.

The enhanced design of the aggregate functions

Data Viewer

Improved Spatial Viewer

Spatial Viewer features the object type and its coordinates.

SpatiaL Viewer refinement

Extended Data Types Support

ENUM, GEOMETRY, and UNSIGNED NUMERIC data types have been supported in the Data Editor column headers.

dbForge Studio for MySQL now supports more data types

Other Improvements

  • Improved Product Update Manager.
  • Digital signature for the installation file.
  • Support for SHA256 Authentication when connecting to MySQL.

One Response to “No one has ever imagined dbForge would do it to Google Sheets!”

  1. Junaid Atari Says:

    Awesome features, Truly marvelous

Leave a Comment