With dbForge Fusion, Devart continues its initiative to produce efficient database experiences for all the people in MySQL world.
New features in dbForge Fusion for MySQL, v4.50 include:
Support of MS Visual Studio 2010
Now all the tools of dbForge Fusion for MySQL are available in MS Visual Studio 2010.
More freedom for backing up schemas
Schema Export wizard has been totally redesigned to Database Backup to enable users to back up schemas in automatic mode using Windows task scheduler, save backup options for future use, view automatically complied log file. Besides, old backup files are automatically removed based on date or quantity.
New tool for database developers - Query Profiler
dbForge Fusion 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.
- 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
Data comparison and synchronization of any databases
Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it compares and synchronizes database of any length with significant performance improvement. To customize comparison and synchronization, the users can use new options, change synchronization direction in one click, and quickly filter tables in comparison results. An additional benefit is generating accurate comparison reports in HTML and Excel formats.
Advanced query building
Now Query Builder, a powerful tool for visual query creating, is tailored for creating complex conditions with several clicks. The new power is based on optimized performance of the Selection tab in the expression editor, visual addition of subqueries to any part of the main query, new Wrap to Subquery option to wrap tables into a subquery, optimized navigation in the editor, particularly between subqueries and other features.
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 of Database Explorer and called ‘Generate Script As’.
Improved schema comparison
- Extended capabilities of Schema Comparison wizard
- New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns