Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

Choose an edition that suits you best

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

Enterprise edition provides all the features available.
Professional edition includes advanced tools and features.
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.

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

Compatibility

Enterprise
Professional
Standard
Express
SQL Server 2022
Yes
Yes
Yes
Yes
SQL Server 2005 - 2019
Yes
Yes
Yes
Yes
SQL Server 2000
Yes
Yes
Yes
Yes
SQL Server installed on Linux
Yes
Yes
Yes
Yes
Azure SQL Database (SQL DB)
Yes
Yes
Yes
Yes
Azure Synapse Analytics (formerly Azure SQL Data Warehouse (SQL DW)) Serverless but not Dedicated
Yes
Yes
Yes
Yes
Azure SQL Managed Instance (SQL MI)
Yes
Yes
Yes
Yes
Microsoft Entra multi-factor authentication (MFA) (formerly Azure Active Directory (Azure AD))
Yes
Yes
Yes
Yes
Microsoft Visual Studio 2015 - 2022
New
Yes
Yes
Yes
Yes
SQL Server Management Studio 2016, 17, 18, 19, and 20
Yes
Yes
Yes
Yes
Intelligence Coding

Intelligent SQL Completion

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

T-SQL Formatting

Enterprise
Professional
Standard
Express
SQL formatting
Demo
Yes
Yes
Yes
Yes
SQL formatting with a wide set of options and customizable formatting styles
Yes
Yes
Yes
Yes
Database identifier case synchronization
Demo
Yes
Yes
Yes
Yes
Individual word recognition in CamelCase identifiers
Yes
Yes
Yes
Yes
Automatically format on paste
Yes
Yes
Yes
Yes
Database letter case coherence (formatting with the dictionary)
Yes
Yes
Yes
No
Word recognition in CamelCase identifiers
Demo
Yes
Yes
Yes
Yes
Automatically format completed statement on delimiter
Demo
Yes
Yes
Yes
Yes
Formatting in files and directories
Screenshot
Yes
Yes
Yes
No
Disable formatting for a certain block of code (noformat tag)
Yes
Yes
Yes
No
Adjust keyword case on typing
Demo
Yes
Yes
Yes
No
Disable formatting for a block of code (noformat tag)
Demo
Yes
Yes
Yes
No
Wide range of predefined formatting profiles
Demo
Yes
Yes
Yes
No
SQL Formatting command-line interface
Screenshot
Yes
Yes
No
No
CLI Wizard for SQL Formatting
Yes
Yes
Yes
No
T-SQL Code Analyzer

T-SQL Code Analyzer

Enterprise
Professional
Standard
Express
Check T-SQL code for compliance with best practices
New
Yes
No
No
No
Customize code analysis profiles
New
Yes
No
No
No
Coding conventions and standardizing

Code Refactoring

Enterprise
Professional
Standard
Express
Refactoring aliases and custom alias mapping
Yes
Yes
No
No
Renaming objects and variables
Yes
Yes
No
No
Enclosing needed identifiers in square brackets
Demo
Yes
Yes
No
No
Smart rename
Demo
Yes
Yes
No
No
Semicolon insertion
Demo
Yes
Yes
No
No
T-SQL Debugger
Demo
Yes
Yes
No
No
Find invalid objects
Screenshot
Yes
Yes
No
No
Find Invalid Objects command-line interface
New
Yes
Yes
No
No
CLI Wizard for Find Invalid Objects
New
Yes
Yes
Yes
No
Productivity Extension

Productivity Extension

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

Automation

Enterprise
Professional
Standard
Express
SQL Formatting command-line interface
Yes
Yes
No
No
CLI Wizard for SQL Formatting
Yes
Yes
Yes
No
Find Invalid Objects command-line interface
New
Yes
Yes
No
No
CLI Wizard for Find Invalid Objects
New
Yes
Yes
Yes
No
$199.95
Buy Now
$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.