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

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
  • Support of command line interface. You can back up schemas in automatic mode using Windows task scheduler
  • 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 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

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 databases of any size
  • 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 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

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 shortcut menu and called Create Script As.

A few improvements in 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

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