Devart is delighted to present the new version of its powerful T-SQL code autocompletion and formatting tool — SQL Complete v3.1, which now comes with numberous enhancements in both Standard and free Express editions. With the new version, users can benefit from Linked Servers compatibility, extended SQL statement support and a new Highlight Occurrences option. Improvements in code completion usability, customization of installation process and tracing support all are intended to make users work faster and more convenient.

dbForge SQL Complete is a useful add-in for SQL Server Management Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. SQL Complete prompts the most appropriate expressions when users are writing SQL code. Besides extension of List Members, Complete Word, and Parameter Info features, SQL Complete adds SQL Formatter in order to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

With 3.1 version, database developers and administrators can enjoy several new useful features:

Linked servers support

The new version of SQL Complete provides support for IntelliSense when working with linked servers. Now users can type their queries with the kind of IntelliSense they are accustomed to even when using all advantages of linked servers configuration.

SQL statements support extended

Standard edition provides support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements.

New Highlight Occurrences option

The new option allows to turn highlighting of occurrences on and off. Besides, all existing options have been rearranged to improve the product's usability.

Among the enhancements of existing features, it is worth to mention the following:

Usability of code completion improvement

The rules for showing suggestion list especially when editing existing SQL queries were revised. Now the suggestion list does not appear for arithmetic operations, numbers, and semicolons.

Installation process customization

Devart improved the product's usability based on users requests. Now developers can select the development environment in which SQL Complete will function when installing the add-in.

Tracing support

Tracing support enables Devart to find and fix errors in the application in a fast and efficient way. In case users encounter any problems with SQL Complete, they can run tracing function and send the created tracing report to Devart, which can ease processing their request significantly.

SQL Complete v3.1 Express (free) Edition users can enjoy extended support of SQL statements (DROP, EXEC, DECLARE, and SET), variables and parameters support, and Qualify Column Names option added.

Pricing and Availability

Developers can give the updated 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 at as little as $99.95 per single user.

The users who don't need advanced code completion features but want to get more than SSMS IntelliSense can give, are always welcome to try free Express edition.

To leave feedback, users are welcome go to the dbForge SQL Complete feedback page. The Devart team is looking forward to receiving any comments or suggestions.

##
About Devart

Devart is a widely recognized provider of database connectivity solutions and tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite.

Since 1998, Devart is focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Devart solutions provide the fastest data access available on the market and the broadest database support to thousands of industry professionals.

For additional information about Devart, visit About Devart: Brief Information About Company