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

Last modified: September 26, 2024

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)