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

New Tool for Visual Database Development - Database Designer

Database Designer is a powerful visual design tool for database development that allows you to build a clear and effective database structure visually, see the complete picture representing all the tables, foreign key relations between them, views, and stored routines of your database. It eases access to the database objects for viewing their properties, editing, retrieving data, executing stored routines. With Database Designer you also can perform reverse engineering of your databases to IDEF1X or IE diagrams, which can be easily printed.

Improved Schema Comparison

  • Schema Synchronization Wizard which eases synchronization process.
  • Schema Update Script window for viewing update script statements for selected object in the SchemaComparison document.
  • Added object grouping by Objects Type, Operation, Difference, No Group.
  • Added copying connection and database settings from source to target and from target to source in the New Schema Comparison Dialog Box.
  • Added object filtering by name.
  • Added Include in Synchronization column with check boxes to SchemaComparison document to simplify excluding/including database objects to synchronization.

Enhanced Data Comparison

Custom database object mapping was added, which allows you to compare data database objects with different names and structure and compare table data with view data. You can also use new Ignore Case, Ignore Spaces, Ignore Underscores options to tune automatic mapping, and easily remap custom mapped objects with automatic mapping. DataComparison document filtering improved. New Data Comparison Wizard now has convenient navigation between pages and allows you to copy connection settings between source. Data Synchronization Wizard allows you to customize data synchronization. Data comparison and synchronization performance greatly increased. Now you can compare only view data.

Execute Script Wizard

Execute Script Wizard allows you to execute large scripts without opening them and loading the whole script in memory. When you try to open too large script, you will be prompted to execute it instead.

Other New Features

  • MARIA table engine supported.
  • Compression for connections to MySQL supported.
  • Correlated subqueries supported in Query Builder.
  • Support for different encodings in SQL, XML and text files added.
  • Added options for controlling script size limit when code editor features are turned off.
  • Spreadsheet like data selection in grid with mouse pointer or SHIFT and CTRL keys is now possible.