dbForge SQL Complete

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Our regular prices are shown below. Please logon to see your discounted prices.

dbForge SQL Complete V3.1.5  

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What’s new in dbForge SQL Complete V3.1.5?

• Linked servers support
• SQL statements support extended. The Standard Edition provides support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements
• Highlight Occurrences on/off option is added
• Usability of code completion improvement
• Installation process customization with the ability to integrate SQL Complete to different development environments is supported
• Tracing support

What’s new in dbForge SQL Complete V3.0?

New SQL Server versions support

• SQL Server 2011 (codename Denali)
• SQL Azure
• SQL Server Compact edition

Added integration into Visual Studio

• Visual Studio 2010: Professional, Premium, and Ultimate editions
• Visual Studio 2008: Professional and Team System editions

"Go to definition" for database objects

• This function allows navigating from the code editor to the object in the Object Explorer (Server Explorer in VS) tree.

Code Snippets - This feature makes it easy and convenient to use fragments of code over and over. The new functionality includes:

• Showing code templates in a dropdown list
• Opening templates on pressing Tab
• Adding and editing templates with the help of templates manager
• Possibility to add parameters to templates.

New code completion features

• IntelliSense for temporary tables and table variables
• Expand EXEC statement feature. All parameters with value stoppers are inserted automatically on pressing Tab
• sys.sp_* procedures are now suggested without schema prefix in EXEC statement
• Expand ALTER statement for procedure, function, view, and trigger. Object body is inserted into the document automatically on pressing Tab
• Suggestions for DROP statements added
• Context-sensitive code completion for CREATE TRIGGER statement
• Extended support for T-SQL DECLARE statement
• Option for including default schema (dbo) into object name when pasting it into the text
• Hierarchyid data type support in code completion
• Document Outline window
• This feature makes navigating through large SQL documents a real pleasure. The Document Outline window shows the structure of the current document. Besides, a user can synchronize structure with text right from the code.

Highlight occurrences of an identifier

• This feature allows users to see all entries of an identifier in the document text. When the cursor is on the identifier, after a time lag all occurrences of this identifier into the text are highlighted.

SQL formatting component improved

• Stream formatting for large documents. Application no longer hangs when formatting large SQL document. User can cancel the formatting process
• Common table expression formatting supported
• New formatting options for indenting JOIN clauses
• Message for invalid statements

Quick database object information extended

• Tooltip with parameters and descriptions of procedures and functions is shown
• Tooltip with columns list when the mouse cursor hovers over the asterisk in the SELECT list is shown
• For the alias in the FROM list, a table or expression with the list of columns is shown (if possible)
• Now name, type, keys, and some other properties are shown for columns
• Quick info is shown for the dropdown list items

"Execute current statement" feature

• Now users can execute the current SQL statement (i.e. the one where the input cursor is located) in the document using the hot key.

Performance improvements

• Formatting speed increased
• Parsing speed of complex statements increased

dbForge SQL Complete Key Features

• Context-based code completion - dbForge SQL Complete thoroughly defines context to predict what you want to type next. The intellisense only prompts relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. Press Enter and continue with your query.
• Parameter Info - When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint. Get the necessary information promptly without browsing external documentation.
• Customizable SQL formatting - Produce clear and well-formatted code without worrying about indents, whitespace, wrapping, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.
• SQL Complete vs Microsoft native IntelliSense® - dbForge SQL Complete provides intellisense for SQL Server 2000, 2005, 2008, regardless of SSMS versions. Native intellisense does not work with those SQL Server versions that differ from your SMSS version. For example, SQL Server Management Studio 2008 will work only with SQL Server 2008.
• Smart filtering to suggest relative keywords and objects – dbForge SQL Complete filters the suggestion list based on various criteria: first typed symbols, whitespace, camel case or a square bracket. You can be sure, whatever you type, suggestions will be just what you wanted.
• Context-based sorting of suggestions in the list – dbForge SQL Complete saves you time by sorting names of database objects by type, and displaying most relevant suggestions in the top of the list; others are moved to the bottom.
• Determining a current database or schema - dbForge SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query. The names of the current database or schema are determined based on connection properties of the current SQL document. Besides, SQL Complete finds USE statements in the code and changes the current database for subsequent SQL statements.
• Expanding a list of columns - You can replace the * asterisk symbol with the list of columns from the required table or view on pressing the Tab key.
• Suggesting conditions for JOIN statements - SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
• Automatic alias generation - dbForge SQL Complete automatically generates an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of your SQL document.
• Semi-transparent view of the suggestion box - When your code is overlapped by the suggestion box, do not close the suggestion box. Hold Ctrl to make the suggestion box switch to a semi-transparent view.
• Suggestions of T-SQL statements in procedures and functions: dbForge SQL Complete supports: DECLARE statements for local variables, cursor variables, and table definitions; cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements; context for such control-of-flow as BEGIN...END, GOTO, IF...ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY...CATCH, CASE, RAISERROR.