Company News

dbForge SQL Complete 4.0

SQL Complete 4.0 with Superior SQL Formatter is Here!

December 13, 2012

Devart Team is glad to announce the new release of SQL Complete v4.0. We have analyzed multiple user suggestions and completely re-designed SQL formatter in order to ensure supreme settings flexibility and company coding style standards unification. Also, we have improved code completion usability and expanded SQL code refactoring features.

Brand new SQL Formatter component

We have revised and improved this essential component. Pivotal new formatting features include:

Formatting profile introduced

  • Formatting preferences stored in an individual file

    Personalize SQL formatting settings and save them in a single .xml file for convenient handling.

  • Multiple formatting profiles and profile import supported

    Activate whichever profile that suits your needs best, import and export profiles.

  • Single-profile for multiple workstations

    Share your settings with colleagues to meet the company's code-formatting standards.

New formatting options editor

  • Option quick search

    Use quick search filter when editing formatting settings.

  • Sample code displays formatting according to current formatting settings

    Instant preview for introduced changes.

  • Editable sample code formatting preview

    Insert a piece of your own code into the preview field to see the way it looks like with applied SQL Complete formatting settings.

Enhanced formatting settings

  • Any SQL-statement formatting can now be adjusted independently and more precisely

    Get unique formatting for each statement type.

  • Formatting settings for sub-queries added

    Sub-queries can now be formatted separately from the queries and other query types' sub-queries.

  • Word recognition for different identifier cases

    Switch between UPPER, lower or CamelCase - individual words will still be recognized.

  • Independent built-in datatype case formatting settings

New SQL code refactoring features

With the new version, we are taking the product to a new level.

Code and database identifier case synchronization

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

Stored procedure call expansion

It takes a single click to transform EXECUTE statement into a code block containing the procedure body. Execution logic is preserved, which allows easier code debugging.

New code completion features

  • Table order in ON condition of suggested JOIN clause can now be reversed. Behavior can be toggled in the options menu
  • Inserted columns in SELECTs are now automatically qualified with a table alias. Behavior can be toggled in the options menu
  • 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 slightly improved
  • The Express edition has been enhanced with code completion for temporary tables

Integration with SSDT in Visual Studio 2010/2012

Last but not least piece of news: developers that have employed SQL Server Data Tools in Visual Studio 2010 and 2012 can now also benefit from using SQL Editor with SQL Complete features.

Availability

Give the new version dbForge SQL Complete a test drive by downloading the 30-day trial Standard edition at the product download page. SQL Complete's Standard edition is available for an estimated retail price of $119.95.

Get more than SSMS IntelliSense has to offer for free with the Express edition.

Provide feedback at the dbForge SQL Complete feedback page. The Devart team is looking forward to receiving your comments and suggestions.