What’s New in dbForge Schema Compare for MySQL, v3.0

Improved code completion

  • Column picker feature allows selecting multiple column suggestions from drop-down list
  • Asterisk expansion in SELECT statements is added
  • Context-specific suggestions is improved
  • Quick object information is improved
  • JOIN clause autogeneration is added
  • Autogeneration of table aliases is added
  • Sorting suggested keywords by relevance is added

  • Highlighting occurrences of an identifier in SQL document is added

  • Performance of describing objects’ metadata is improved

Improved code formatter

  • Format profiles are supported
  • Formatting options are extended

  • Preview window for viewing formatted code with support of code highlighting and editing is added

  • Search of options by name is added

New window docking system

  • Switching between tool windows on CTRL+TAB is supported

Minor features

  • If there is more than one SELECT statement in a document, query results are now displayed on separate tabs in the Data window after execution
  • Support of MySQL pluggable authentication on creating a connection to MySQL server is added
  • Support of Windows authentication on creating a connection to MySQL server

  • F5 shortcut now works for execution of a selected SQL fragment as well as for the entire script

  • New skins added (Metropolis, Windows 7 and VS2010)