Choose an edition that suits you best

The product comes in three editions: Professional, Standard, and Express.

Professional edition provides all the features available.
Standard edition offers the tool's essential features.
Express is a free edition that provides basic code completion functionality.

The Express Edition will be activated after the expiration of the trial.

Most popular
Professional
Subscription
Full-featured edition
$149.95
Buy now
Standard
Subscription
Essential features edition
$129.95
Buy now
Express
Basic functionality
Free
Download
Features
Compatibility

Compatibility

Professional
Standard
Express
SQL Server 2022
New
Yes
Yes
Yes
SQL Server 2005 - 2019
Yes
Yes
Yes
SQL Server 2000
Yes
Yes
Yes
SQL Server installed on Linux
Yes
Yes
Yes
Azure SQL Database (SQL DB)
Yes
Yes
Yes
Azure SQL Data Warehouse (SQL DW)
Yes
Yes
Yes
Azure SQL Managed Instance (SQL MI)
Yes
Yes
Yes
Azure Active Directory (Azure AD) multi-factor authentication (MFA)
Yes
Yes
Yes
Microsoft Visual Studio 2012 - 2019
Yes
Yes
Yes
SQL Server Management Studio 2014, 2016, 17, 18, 19, and 20
Yes
Yes
Yes
SQL Server Management Studio 2012
Yes
Yes
Yes
Intelligence Coding

Intelligent SQL Completion

Professional
Standard
Express
Smart suggestions
Screenshot
Yes
Yes
Yes
Wise filtering in the suggestion list
Screenshot
Yes
Yes
Yes
Database context detection
Screenshot
Yes
Yes
Yes
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
Screenshot
Yes
Yes
Yes
Parameter information for functions
Screenshot
Yes
Yes
Yes
Semi-transparent view of the suggestion box
Screenshot
Yes
Yes
Yes
Prompting common table expressions (CTE)
Screenshot
Yes
Yes
Yes
Context-sensitive suggestion of keywords
Demo
Yes
Yes
Yes
Quick object information
Demo
Yes
Yes
Name suggestions for objects on linked servers
Screenshot
Yes
Yes
No
Column picker for quick list building
Demo
Yes
Yes
No
JOIN clause auto generation
Demo
Yes
Yes
No
Wildcard expansion
Demo
Yes
Yes
No
INSERT, EXEC, and ALTER statements expansion
Demo
Yes
Yes
No
UPDATE statements expansion
Demo
Yes
Yes
No
Auto-generation of table aliases
Demo
Yes
Yes
No
Context-sensitive object suggestions for T-SQL code, DDL, and security statements
Screenshot
Yes
Yes
No
SQL snippets
Demo
Yes
Yes
No
Code completion in SQLCMD mode
Screenshot
Yes
Yes
No
Identifier occurrences highlighting
Screenshot
Yes
Yes
No
Sorting suggested keywords by relevance
Demo
Yes
Yes
No
Custom alias mapping
Demo
Yes
Yes
No
Phrase completion
Screenshot
Yes
Yes
No
Pair highlighting (BEGIN END; CASE END)
Demo
Yes
Yes
No
Highlight of matching COLUMNS and VALUES in the INSERT statement
Screenshot
Yes
Yes
No
Show popup with column name in the values area for INSERT statement
Demo
Yes
Yes
No
Get Row Count
Screenshot
Yes
Yes
No
Expanding sp_executesql
Demo
Yes
Yes
No
Named Regions
Screenshot
Yes
Yes
No
Data Sensitivity Classification suggestions
Screenshot
Yes
Yes
No
SSDT Project
Screenshot
Yes
Yes
No
T-SQL Formatting

T-SQL Formatting

Professional
Standard
Express
SQL formatting
Demo
Yes
Yes
Yes
Database identifier case synchronization
Demo
Yes
Yes
Yes
Word recognition in CamelCase identifiers
Demo
Yes
Yes
Yes
SQL Formatting command-line interface
Screenshot
Yes
No
No
Formatting in files and directories
Screenshot
Yes
Yes
No
Adjust keyword case on typing
Demo
Yes
Yes
No
Disable formatting for a block of code (noformat tag)
Demo
Yes
Yes
No
Wide range of predefined formatting profiles
Demo
Yes
Yes
No
Coding conventions and standardizing

Code Refactoring

Professional
Standard
Express
Enclosing needed identifiers in square brackets
Demo
Yes
No
No
Smart rename
Demo
Yes
No
No
Semicolon insertion
Demo
Yes
No
No
T-SQL Debugger
Demo
Yes
No
No
Find invalid objects
Screenshot
Yes
No
No
Productivity Extension

Productivity Extension

Professional
Standard
Express
Execution History
Screenshot
Yes
Yes
Yes
Execute current statement
Screenshot
Yes
Yes
Yes
"Go to definition" for database objects
Demo
Yes
No
No
Document outline window
Demo
Yes
No
No
Statement navigation
Demo
Yes
No
No
Execution warnings
Screenshot
Yes
No
No
CRUD generator
Screenshot
Yes
No
No
Convert EXEC to script
Demo
Yes
No
No
Run script on multiple databases
Screenshot
Yes
No
No
Execution notifications
Demo
Yes
No
No
Transaction reminder
Screenshot
Yes
No
No
Find in Results Grid
Screenshot
Yes
No
No
Grid Aggregates
Screenshot
Yes
No
No
Navigation between the BEGIN and END pair
Demo
Yes
No
No
Navigation between BEGIN TRY/END TRY
Demo
Yes
No
No
Navigation between BEGIN CATCH/END CATCH
Demo
Yes
No
No
Navigation between CASE and END
Demo
Yes
No
No
Navigation between COLUMNS and VALUES in the INSERT statement
Demo
Yes
No
No
Generate Script As from SSMS data grid
Screenshot
Yes
No
No
Restore last document session
Demo
Yes
No
No
Custom SSMS main window title & SQL document tabs caption
Screenshot
Yes
No
No
Close unmodified tabs
Screenshot
Yes
No
No
Tabs coloring as well as Status bar and Object explorer coloring
Screenshot
Yes
No
No
Script object as CREATE/ALTER
Demo
Yes
No
No
Excluding databases from prompts
Screenshot
Yes
No
No
Copy Results Grid Headers (Column Names + Types)
Screenshot
Yes
No
No
Results Grid Data Visualizers
Screenshot
Yes
No
No
Proportional tab width and the ability to control what is displayed in the tab name
Screenshot
Yes
No
No

$149.95
Buy Now
$129.95
Buy Now
FREE
Download

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.