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 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

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

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

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 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

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 Templates feature is now renamed to Code Snippets and extended with the Snippets Manager window for adding and editing SQL templates.

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

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

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

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

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

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 (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

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