What’s New in dbForge Fusion for MySQL, v4.5

Support of Visual Studio 2010

You can use all the tools of dbForge Fusion for MySQL integrated into Visual Studio 2010.

Data Import

Guided by a click-and-pick wizard, the users can easily import data from seven widely-popular formats (CSV, DBF, MS Access, MS Excel, ODBC, Text, XML) with a multitude of settings to meticulously tune the data. Microsoft Excel formats are supported as 2007, 2003 formats, and earlier.

Improved Data Editor

Up to 40 improvements were implemented to create quicker, easier, and more delighted ways for data management. The Data Editor spares tens of mouse clicks a day for you saying nothing of tens of frowns.

Pivot Table

The users can convert large amounts of data into compact and informative summaries - pivot tables. They can rearrange any obscure data by a simple drag of a mouse to get the layout best for understanding data relations and dependencies.

Data Reports

Every user can benefit from a modern way of generating reports. Less time and manual work is required, from getting required data from a database, analyzing, to printing it as a smart, clear, and stylish report tuned for each particular case.

Redesigned Database Backup Wizard

Schema Export wizard has been totally redesigned to provide more freedom for backing up schemas. It features the following:

  • Capability to save backup options for future use
  • Automatic archiving of schema backup scripts
  • Writing a report about backup process into a log file
  • Automatic removing old backup files based on date or quantity

New Tool for Database Developers - Query Profiler

dbForge Fusion for MySQL offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.

Additional benefits:

  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Capability to compare profiling results in two clicks
  • Capability to print profiling results

Improved Query Builder Tool

Meet a stronger Query Builder tailored for creating complex conditions with several clicks. The new power is based on the following:

  • Optimized performance of the Selection tab in the expression editor
  • New Wrap to Subquery option to wrap tables into a subquery
  • Visual addition of subqueries to any part of the main query
  • Optimized navigation in the editor, particularly between subqueries
  • Capability to edit view location in the query document
  • Joins show connection direction, better described connection properties
  • New skin for objects on the diagram

Revised Data Comparison Tool

Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it embraces the following:

  • Capability to compare and synchronize database of any length
  • Increased performance of comparison processes
  • Generating accurate comparison reports in HTML and Excel formats
  • Capability to change synchronization direction in one click
  • New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float types
  • Quick filtering tables in comparison results
  • Optimized object management during custom synchronization
  • Capability to edit values of default comparison options
  • New synchronization option Exclude Comments

Improved Schema Comparison Tool

  • Extended capabilities of Schema Comparison wizard
  • New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
  • Generating schema comparison reports to keep records of schema changes

Virtual Relations on Database Diagram

Besides physically existing foreign key relations, dbForge Fusion allows creating virtual relations. They help create relations between those tables which storage engine do not support foreign keys. Later virtual relations can be easily converted into physical foreign keys.

Database Changer

The users can easily select a required database within a current connection to execute SQL scripts and queries. There is no need to type USE statement to switch a database, and no database prefix is required to define what database to refer to. Also, an option to disable triggers, and the WHERE filter, that can be accessed from the Mapping page, were added to the Data Synchronization wizard. SQL Filter can be used to specify the expression to filter rows included into comparison.

Product Update Manager

Besides viewing the update information of dbForge Fusion, the users can customize the update process as they like.

Now, users can add hyperlinks to any files in database diagram notes.

Quick Generating Template SQL Scripts for Database Objects

Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template SQL scripts CREATE, DROP, SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in the context menu and called Create Script As.

Other Improvements

  • New SQL document view layout - now you can see query text and retrieved data at the same time
  • Generate DDL wizard was renamed into Generate Schema Script
  • SQL formatting improvements
  • Stored procedure/function editor redesign
  • SQL execution parameter editor redesign