What’s New in dbForge Fusion for MySQL, v6.0


  • Integrates into Visual Studio 2012 and supports all IDE skins
  • One installation file to integrate the add-in into both Visual Studio 2010 and 2012: the required IDE can be selected during installation
  • Integrates into dotConnect for MySQL

MySQL Connectivity

  • MySQL server v5.5 is supported
  • Amazon RDS is supported
  • Support of MySQL pluggable authentication on creating a connection to MySQL server is added
  • Support of Windows authentication on creating a connection to MySQL server
  • New encodings were added to the encoding list in the Connection Properties dialog

Database Refactoring - unique feature

This feature allows renaming objects in a database and automatically updates links to these objects in the whole database.

  • Renaming of tables, columns, views, procedures, functions, and indexes is supported
  • Preview of changes in the database with possibility to cancel them selectively is supported
  • Possibility to generate refactoring script of a database without changing it is supported
  • Refactoring functions can be accessed from the tree and object editors
  • Possibility to rename several columns from object editor
  • If an error in processing dependencies is encountered, a user can fix it manually

Query Builder with support of DML statements and usability improvements

  • Visual building of INSERT, UPDATE, and DELETE statements is supported
  • Conversion of SELECT queries into INSERT statements is supported
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition is supported
  • Execution of separate subqueries to check their correctness without leaving diagram interface
  • Usability of visual expression editor is improved
  • Query type is indicated on the diagram surface

Improved database object editors

  • Editable column grid in the table editor now allows adding and editing columns without opening the pop-up dialog
  • Full-text search in the column grid in the table editor is added
  • Schema changes can now be viewed before updating database
  • Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
  • F7 shortcut can now be used to toggle all editor views
  • Stored procedure editor Design tab is redesigned
  • Heuristics is supported

New features in the Data Compare tool

  • New data comparison reports now contain table data (not just a summary)
  • Comparison of custom query results (along with tables and views) is added
  • “One-to-many” objects mapping when addressing columns that were separated as a table in the target database is added
  • Possibility to include objects into comparison by mask, which is useful when comparing groups of tables is implemented
  • Full-text data search in comparison results is supported
  • Analysis of comparison results is improved: ‘Hide unmodified columns’ option, per-column difference counters are added

Improved Code Completion

  • Column picker feature allows selecting multiple column suggestions from drop-down list
  • Asterisk expansion in SELECT statements is added
  • Context-specific suggestions is improved
  • Quick object information is improved
  • JOIN clause autogeneration is added
  • Autogeneration of table aliases is added
  • Sorting suggested keywords by relevance is added
  • Highlighting occurrences of an identifier in SQL document is added
  • Performance of describing objects’ metadata is improved

Code Snippets Manager

Code Templates feature is now renamed to Code Snippets and extended with the Snippets Manager window for adding and editing SQL templates.

Improved Code Formatter

  • Format profiles are supported
  • Formatting options are extended
  • Preview window for viewing formatted code with support of code highlighting and editing is added
  • Search of options by name is added

Master-Detail Browser

Explore and analyze master-detail data in a convenient browser with the following features:

  • Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
  • Print setup for master-detail browser is supported
  • Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation
  • The document allows saving and loading data and diagram for future use
  • Sorting and filtering data in the Data view
  • Ability to analyze self-referencing tables

Object Dependency Tree - unique feature

  • Easily explore object’s references and dependents in Database Explorer
  • Compilation of dependants for debugging is now also available through the object’s context menu

Enhanced Data Editor

Newly added features and a few totally redesigned ones provide even more freedom when working with data.

  • Foreign Key lookup editor added
  • Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
  • A few indications added to inform user about Data Editor’s state
  • Editing of tables in join statements is enabled now
  • Option for numbering records added
  • Copy data with header functionality added
  • Ability to build graphical representation of your data with fully functional wizard added

Improved Security Manager

  • Ability to edit permissions for several users added
  • Virtual roles for users were added to allow granting a definite set of permissions to selected users
  • Grouping by hosts in the users list tree added
  • Editing users and working with Security Manager window simplified

Data Export and Data Import improvements

  • Ability to export data from several tables at once added
  • Data export to INSERT, UPDATE, DELETE, and MERGE statements is supported
  • Ability to export query results as well as data directly from a table is supported
  • Quick generation of INSERT statements from data grid without opening wizard is supported

Object Viewer - a simple way to view object’s details

Object Viewer (formerly known as Summary Window) was totally redesigned to provide an easier way for analyzing objects and their structure:

  • There are three views to display properties, DDL (text), and data of the selected object
  • Inner navigation through object hierarchy
  • History with previously viewed objects
  • More information about each object is displayed in the Properties view now

Other improvements

  • Ability to view internal SQL queries that are sent to the server with parameter’s values added
  • Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
  • Highlighting of differences on comparing SQL profiling results added
  • More informative progress during Schema and Data comparison
  • If there is more than one SELECT statement in a document, query results are now displayed on separate tabs in the Data window after execution
  • F5 shortcut now works for execution of a selected SQL fragment as well as for the entire script
  • Export of connection list from the application together with other settings is supported