Editions of dbForge SQL Complete

dbForge SQL Complete comes in two editions: Express and Standard.

Express is a free edition that provides basic code completion functionality. To see advantages of dbForge SQL Complete over Microsoft SQL Server Management Studio 2017 (SSMS), please refer to the SQL Complete - Alternative to Native Microsoft T-SQL Intellisense article.

Standard edition extends the Express edition's functionality. 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.

The matrix below compares features of dbForge SQL Complete Express and Standard editions.

Features

Exp

Std

Name suggestions for major objects1
Yes
Yes
Screenshot
Name suggestions for advanced objects2
Partially supported
Yes
Difference
Smart filtering in the suggestion list
Yes
Yes
Screenshot
Context-sensitive suggestion of keywords
Partially supported
Yes
Difference
Database context detection
Yes
Yes
Screenshot
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements3
Yes
Yes
Screenshot
Parameter information for functions
Yes
Yes
Screenshot
Quick object information
Partially supported
Yes
Difference
SQL formatting
Partially supported
Yes
Difference
Execute current statement
Yes
Yes
Screenshot
Semi-transparent view of the suggestion box
Yes
Yes
Screenshot
Statement navigation
No
Yes
Demo
Formatting in files and directories
No
Yes
Screenshot
Enclosing needed identifiers in square brackets
No
Yes
Screenshot
Database identifier case synchronization
Yes
Yes
Demo
Individual word recognition in CamelCase identifiers
Yes
Yes
Demo
Name suggestions for objects on linked servers
No
Yes
Screenshot
Column picker for quick list building
No
Yes
Demo
JOIN clause auto generation
No
Yes
Demo
Wildcard expansion
No
Yes
Demo
INSERT, EXEC, and ALTER statements expansion
No
Yes
Demo
UPDATE statements expansion
No
Yes
Demo
Stored procedure expansion
No
Yes
Screenshot
Auto-generation of table aliases
No
Yes
Demo
Code completion for common table expressions (CTE)
Yes
Yes
Screenshot
Context-sensitive object suggestions for T-SQL code, DDL, and security statements3
No
Yes
Screenshot
SQL snippets
No
Yes
Demo
Document outline window 4
No
Yes
Screenshot
"Go to definition" for database objects
No
Yes
Demo
Adjust keyword case on typing
No
Yes
Demo
Disable formatting for a certain block of code (noformat tag)
No
Yes
Screenshot
Code completion in SQLCMD mode
No
Yes
Screenshot
Identifier occurrences highlighting
No
Yes
Screenshot
Sorting suggested keywords by relevance
No
Yes
Difference
Import Export Settings Wizard
No
Yes
Screenshot
Custom alias mapping
No
Yes
Screenshot
SQL Refactoring
No
Yes
Demo
Phrase completion
No
Yes
Screenshot
Pair highlighting (BEGIN END; CASE END)
No
Yes
Demo
Navigation between the BEGIN and END pair
No
Yes
Demo
Execution History 5
Partially supported
Yes
Screenshot
Execution warnings
No
Yes
Screenshot
CRUD generator
No
Yes
Screenshot
Run script on multiple databases
No
Yes
Screenshot
Execution notifications
No
Yes
Demo
Transaction reminder
No
Yes
Screenshot
Find in Results Grid
No
Yes
Screenshot
Grid Aggregates
No
Yes
Screenshot
Highlight of matching COLUMNS and VALUES in the INSERT statement
No
Yes
Screenshot
Navigation between COLUMNS and VALUES in the INSERT statement
No
Yes
Demo
Generate Script As from SSMS data grid
No
Yes
Screenshot
Semicolon insertion
No
Yes
Demo
Restore last document session
No
Yes
Demo
Custom SSMS main window title & SQL document tabs caption
No
Yes
Screenshot
Close unmodified tabs
No
Yes
Screenshot
Tabs coloring as well as Status bar and Object explorer coloring Updated
No
Yes
Screenshot
Find invalid objects
No
Yes
Screenshot
Script object as CREATE/ALTER
No
Yes
Demo
Excluding databases from prompts
No
Yes
Screenshot
Get Row Count
No
Yes
Screenshot
Copy Results Grid Headers (Column Names + Types)
No
Yes
Screenshot
Expanding sp_executesql
No
Yes
Screenshot
Named Regions
No
Yes
Screenshot
Results Grid Data Visualizers
No
Yes
Screenshot
Proportional tab width and the ability to control what is displayed in the tab name New
No
Yes
Screenshot

Single License Price

Free

$199.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.

3 To learn more about supported context read the SQL Complete Context article.

4 Document Outline window is supported for Microsoft SQL Server Management Studio 2012 or higher.

5 Express edition saves history for the last 3 days only.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.