Friday, April 19, 2024
HomeProductsMySQL ToolsMore Tools Available: dbForge Studio for MySQL, v4.50!

More Tools Available: dbForge Studio for MySQL, v4.50!

Devart today releases dbForge Studio for MySQL, v4.50 – cutting-edge administration tool and development environment for professional working with MySQL databases.

With dbForge Studio, Devart continues its initiative to produce efficient database experiences for all the people in MySQL world.

New features in dbForge Studio for MySQL, v4.50 include:

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.

How to dump MySQL database
How to backup MySQL database

New tool for database developers – Query Profiler

dbForge Studio 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
How to profile MySQL query
How to profile MySQL query

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 Compare 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 compare tool

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

Check the benefits yourself, download dbForge Studio for MySQL, v4.50 now for free.

Tell us what you think about the new version at dbForge Studio feedback page.

We are looking forward to your comments and suggestions.