Starting from the version 3.00 dbForge Studio for MySQL will be divided into three editions: Express, Standard, and Professional.
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.
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:
Data comparison tool allows complete or partial comparing of data between different schemas. Data differences are conveniently displayed. Data comparison provides the following features:
Highly customizable code formatting allows you to set up various options for different statement kinds. SQL formatting features:
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.
You can check your code and quickly locate errors without using MySQL server. Syntax check of the entire database project is also available.
Query Builder was completely re-designed to meet user needs. SQL syntax support was significantly enhanced. Following features were added:
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.
Following search and replace functionality was added:
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 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.
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.