Editions of dbForge SQL Complete
The matrix below compares features of dbForge SQL Complete Express and Standard.
To see advantages of dbForge SQL Complete over Microsoft SQL Server Management Studio
2008 (SSMS), refer to the SQL Complete
- Alternative to Native Microsoft T-SQL Intellisense article.
Energize your work with a perfect intellisense tool. Buy dbForge SQL Complete Standard,
and it will reward you with the fastest SQL statements writing and extra time for
a cup of coffee.
|
Features
|
Express
|
Standard
|
|
|
|
|
Name suggestions for major objects 1
|
|
|
Screenshot
|
|
Name suggestions for advanced objects 2
|
|
|
Difference
|
|
Smart filtering in the suggestion list
|
|
|
Screenshot
|
|
Context-sensitive suggestion of keywords
|
|
|
Difference
|
|
Database context detection
|
|
|
Screenshot
|
|
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
|
|
|
Screenshot
|
|
Parameter information for functions
|
|
|
Screenshot
|
|
Quick object information
|
|
|
Difference
|
|
SQL formatting Updated!
|
|
|
Difference
|
|
Execute current statement
|
|
|
Screenshot
|
|
Semi-transparent view of the suggestion box
|
|
|
Screenshot
|
|
Code and database idents case synchronizationNew!
|
|
|
Demo
|
|
Individual word recognition in CamelCase identifiersNew!
|
|
|
Demo
|
|
Name suggestions for objects on linked servers
|
|
|
Screenshot
|
|
Column picker for quick list building
|
|
|
Demo
|
|
JOIN clause auto generation
|
|
|
Demo
|
|
Wildcard expansion
|
|
|
Demo
|
|
INSERT, EXEC, and ALTER statements expansion
|
|
|
Demo
|
|
Stored procedure call expansionNew!
|
|
|
Screenshot
|
|
Auto-generation of table aliases
|
|
|
Demo
|
|
Code completion for common table expressions (CTE)
|
|
|
Screenshot
|
|
Context-sensitive object suggestions for T-SQL code, DDL, and security statements
|
|
|
Screenshot
|
|
SQL Snippets
|
|
|
Demo
|
|
Document Outline window
|
|
|
Screenshot
|
|
"Go to definition" for database objects
|
|
|
Demo
|
|
Adjust keyword case on typing
|
|
|
Demo
|
|
Intellisense in SQLCMD mode
|
|
|
Screenshot
|
|
Highlight occurrences of an identifier
|
|
|
Screenshot
|
|
Sorting suggested keywords by relevance
|
|
|
Difference
|
|
Export/Import Settings Wizard
|
|
|
Screenshot
|
|
Single License Price
|
Free
|
$119.95
|
|
1 Major objects are database, schema, table, view, procedure, user and
table-valued function (including CLR), built-in function.
2 Advanced objects are synonym, CLR aggregate, collation, type, XML
schema collection, language, XML and VARCHAR(MAX) data type methods.