Devart SQL Complete v3.1 with Linked Servers, New Statements Support and Usability Improvements

Last Post 07 Oct 2011 04:00 AM by Devart. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Informative
Devart
New Member
New Member

--
07 Oct 2011 04:00 AM
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 MicrosoftT-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 atas 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 po***r 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 http://www.devart.com/company/



Acceptable Use Policy
---