Enterprise is the ultimate edition that, in addition to all essential features of the Professional edition, includes Source Control and Unit Test tools, support for version control and script folder during schema comparison.
Professional is an enhanced edition of the tool that provides such functionality as: Database Synchronization, Data Reports, Pivot Table Designer, and advanced Coding Assistance. This edition also includes support for Command-line interface for some components that allows you to automate routine operations.
Standard edition extends the Express edition's functionality with Data Comparison Tool, Pivot Table Designer, T-SQL Debugger, Query Profiler, advanced Coding Assistance features, and database search options. Moreover, this edition includes enhanced Query Builder, Data Export/Import features and command-line interface for data reporting.
Express is a free edition that provides basic functionality for database development. It includes database Object Editor, security configuration tools, advanced Data Editor, and Export/Import from CSV and ODBC. Also this edition has basic support for Coding Assistance and limited Query Builder features.
1 Context-sensitive object suggestions available only for SELECT, DML, DROP, EXEC, SET, and USE statements.
2 SQL code formatting is available only for SELECT and DML statements.
3 Only basic information about object is shown.
4 The number of schema objects on a diagram is limited to 10.
5 The number of tables is limited to 3, sub-queries are not supported.
6 CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.
7 Limited functionality.
8 The number of formatting options is limited.
9 The query execution history is stored within 3 days.