What’s New in dbForge SQL Complete v4.0

New Formatting Features

Formatting profile introduced

  • As formatting preferences are now stored in an individual file, you can personalize formatting settings and save them in an *.xml file for more convenient handling.
  • Multiply formatting profiles and profile import allow you to activate any profile you need, export and import them.
  • Single profile can be used for multiple workstations now to help you meet company code formatting standard.

New formatting options editor

  • Quick search filter for options will help you edit formatting settings easily.
  • Instant preview of changes in formatting settings allows viewing impact of the applied update.
  • See how inserted code will look like using editable sample code formatting preview.

Enhanced formatting settings

  • Adjust formatting of any type of SQL statement independently.
  • Sub-queries can be formatted separately from parent queries and other query types’ sub-queries.
  • Any case can be used when formatting identifiers (UPPER, lower, CamelCase), as individual words in the identifier will be still recognized.
  • Independent built-in data type case formatting settings.

New SQL Code Refactoring Features

Code and database identifier case synchronization

If your database identifiers were created according to certain adopted rules, then you will have no problems with transforming SQL script identifier case to that of the database.

Stored procedure call expansion

Transform EXECUTE statement into a code block containing the procedure body with ease. As execution logic will be preserved, code debugging will become easier.

New code completion features

  • Option for reversing table order in ON condition of suggested JOIN clause.
  • Qualify inserted columns in SELECTs with a table alias automatically with the help of a new option.
  • Functions are now inserted from suggestion list with braces.
  • Refresh Local Cache and Refresh Suggestions commands now use the same shortcut.
  • ALTER TABLE statement now has context-sensitive identifier suggestion.
  • Run Current Statement command usability is slightly improved.
  • The Express edition has been enhanced with code completion for temporary tables.

Other Features

  • Integration with SSDT in Visual Studio 2010/2012
  • Developers that use SQL Server Data Tools in Visual Studio 2010 and 2012 can now take advantage of SQL Complete features.