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

Editions

Starting from the version 3.00 dbForge Studio for MySQL will be divided into three editions: Express, Standard, and Professional.

  • Express edition provides basic functionality for working with schema objects, user accounts, and SQL scripts. Express edition is free.
  • Standard edition includes all must-have tools for a database developer, such as a debugger, Query Builder, code templates, object search, various export and maintenance wizards.
  • Professional edition features database project development functionality, schema and data comparison tools, SQL formatting and syntax checking.

Database Projects Greatly Improved

Project building to an SQL script is available with support of different build options and build configurations. Project build includes SQL syntax check, reference check, scripts processing with applying database options, and generating the result script or several scripts based on the selected order.

  • Building project to a single script
  • Building project to a collection of scripts
  • Reference check on build
  • Multiple build configurations
  • Adapting build results to specified server version
  • Schema comparison tool integration
  • Refactoring of project objects
  • Easy deleting object from project
  • All project objects in code completion list

Schema Comparison

Schema comparison tool allows you to quickly compare and synchronize either two schemas or a schema and a project. Based on your needs, a target schema can be synchronized with a source one completely or partially. Schema comparison provides the following features:

  • Compare database with database
  • Compare database with project
  • Synchronization between different server versions
  • Comparison results filtering
  • Schema synchronization script generation
  • Per object viewing of DDL differences
  • Exclude objects from synchronization
  • Save and load comparison settings

Data Comparison

Data comparison tool allows complete or partial comparing of data between different schemas. Data differences are conveniently displayed. Data comparison provides the following features:

  • Comparison of large tables
  • Optional view comparison
  • Custom comparison keys support
  • Option for BLOB data comparison
  • Comparison results filtering
  • Data synchronization script generation
  • Per record viewing of data differences
  • Exclude tables and records from synchronization
  • Save and load comparison settings

SQL Formatting

Highly customizable code formatting allows you to set up various options for different statement kinds. SQL formatting features:

  • Automatic formatting on statement delimiter
  • Automatic formatting on paste
  • Formatting of current statement, selected fragment, whole document, or multiple files
  • Many options can be set individually for different kinds of statements
  • Automatic placing new lines and spaces
  • Automatic case setting

Code Refactoring

Renaming of a database object in a script or project is supported. All statements, referencing to this object are automatically updated. All changes can be previewed and disabled. Updating of text strings and comments is also supported.

SQL Syntax Check

You can check your code and quickly locate errors without using MySQL server. Syntax check of the entire database project is also available.

Brand New Query Builder

Query Builder was completely re-designed to meet user needs. SQL syntax support was significantly enhanced. Following features were added:

  • Support for subqueries on any nesting level
  • Powerful expression editor, which allows building very complex conditions without typing code
  • Reworked diagram with much better appearance
  • Most actions can be performed with keyboard shortcuts

Extended Data Export

A range of supported formats for export is increased. Now you can export data even to another database server through ODBC. Following output formats are now available: CVS, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text and XML. Using well-designed Data Export wizard, you can set additional parameters for each output format.

Improved Stored Routine Debugger

  • Support for session and server variables in watches
  • Some server function call processing improved

Search and Replace Extended

Following search and replace functionality was added:

  • Search in data
  • Search in LOB Viewer/Editor
  • Search and replace in project files
  • Search and replace in files on disc

Context-sensitive Help

dbForge Studio for MySQL provides on the fly support during your work. You can press F1 to quickly retrieve reference information about MySQL statements, keywords, data types and built-in functions from SQL editor.

Import and Export Settings

Import and Export Settings Wizard allows you to export and import all your settings, layout, toolbars, keyboard shortcuts. Wizard also allows you to reset settings to their default values. You may export, import, and reset settings completely or partially.

Support of new table features and storage engines

  • Partitioning support
  • Merge engine support
  • Falcon engine support

Summary Window

Summary window is added for quick access to database object properties when browsing schema with Database Explorer. Window displays information about currently selected database object or a collection of objects.