| Full version | Lite version | |||
|---|---|---|---|---|
| Support of SQL Server 2008 | ||||
| Support of new data types: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography | + | + | ||
| Support of table types | + | + | ||
| Support of logon triggers | + | + | ||
| Supports of new backup parameters: compression, buffer count, max transfer size | + | + | ||
| Support of Unicode data | + | + | ||
| Rapid database management and navigation | ||||
| Multiple host/database connections | + | + | ||
| Database properties management | + | + | ||
| Server properties management | + | – | ||
| Registering databases for working with the required databases only | + | + | ||
| Projects to work with the selected database objects only | + | + | ||
| Multiple user-defined tabs for any tree node to access it in one-click. | + | + | ||
| Working with multiple selected objects at a time | + | + | ||
| Grouping/ungrouping registered databases by host name | + | + | ||
| Easy management of all SQL Server objects | ||||
| Creating/dropping databases and schemas | + | + | ||
| Managing tables and all their subobjects: fields, indices, triggers, checks and foreign keys | + | + | ||
| Managing views, procedures and user-defined functions | + | + | ||
| Managing user-defined types, synonyms, DDL triggers, assemblies, aggregates, XML schema collections, defaults and rules | + | + | ||
| Managing partition functions and schemes, full-text catalogs and indices, symmetric and asymmetric keys, certificates | + | + | ||
| Managing jobs, schedules, alerts, operators, endpoints, linked servers, credentials, proxies | + | – | ||
| Duplicating all database objects | + | + | ||
| Viewing dependencies between database objects | + | + | ||
| Advanced data manipulation tools | ||||
| Powerful BLOB viewer/editor with several types of viewing BLOB data | + | – | ||
| Plenty of useful tools such as data grouping, summarizing, fast searching and filtering | + | + | ||
| Master-detail view to work with two linked tables at the same time | + | – | ||
| Table and card views to see data the way you like | + | – | ||
| Support of queries returning multiple result sets | – | – | ||
| Ability to copy and paste selected records | + | – | ||
| Advanced printing system | + | – | ||
| Effective security management | ||||
| Powerful login manager for administering server logins | + | + | ||
| Managing database users and user-defined roles | + | + | ||
| Managing server roles membership | + | + | ||
| Grant manager displaying all database object grants in the form of a grid | + | + | ||
| Viewing and changing object permissions to database roles in object editors | + | + | ||
| Excellent visual and text tools for query building | ||||
| Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax | + | – | ||
| Multiple SQL editors with code completion, syntax highlight and code folding | + | + | ||
| Large script executing (SQL script editor) | + | + | ||
| Ability to view actual and estimated query plan as diagram | + | + | ||
| SQL Formatter (Available from SQL Editor context menu) | + | – | ||
| Favorite Queries (Save and use your frequently used queries easily) | + | – | ||
| Impressive data export and import capabilities | ||||
| Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc. | + | – | ||
| Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV | + | – | ||
| Bulk Insert wizard | + | – | ||
| Exporting data to SQL script as INSERT statement with selecting destination DBMS | + | – | ||
| Visual Database Designer to handle database structure in a few clicks | ||||
| Creating diagram of existing database using Reverse engineering tool | + | – | ||
| Dividing diagram into different subject areas located on separate pages | + | – | ||
| Navigating through diagram using preview navigation to | + | – | ||
| Creating/editing/dropping tables and table fields, visually setting links between them | + | – | ||
| Ability to add comments to diagram | – | – | ||
| Saving as image or printing database diagram | + | – | ||
| Two diagram notations (IDEF1x and IE) | + | – | ||
| A lot of visual customization options | + | – | ||
| Easy-to-use wizards performing SQL Server administrative tasks | ||||
| Backing up database | + | + | ||
| Restoring database | + | + | ||
| Attaching database | + | + | ||
| Detaching database | + | + | ||
| Shrinking database | + | – | ||
| Managing indices | + | – | ||
| Updating statistics | + | – | ||
| Checking database | + | – | ||
| Powerful tools to make your work with SQL Server as easy as it can be | ||||
| Extracting metadata into text files or SQL script editor | + | + | ||
| Powerful print metadata module for creating customizable metadata reports | + | – | ||
| HTML report generator to create a detailed HTML report about your database quickly | + | – | ||
| Managing backup devices | + | + | ||
| Managing database snapshots | + | – | ||
| Viewing SQL Server logs | + | – | ||
| Monitoring SQL Server activity | + | – | ||
| Report designer with clear in use report construction wizard | ||||
| Create Report Wizard allows you to create simple reports in a few clicks | + | – | ||
| Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree | + | – | ||
| New state-of-the-art graphical user interface | ||||
| Office 11 and Windows XP visual schemes support | + | + | ||
| Well-described Wizard System | + | + | ||
| Improved database explorer for easy management of all SQL Server objects | + | + | ||
| MDI and floating-window styles implementation | + | + | ||
| Windows Toolbar to switch between windows easily, like in Windows Task Bar | + | + | ||
| Navigation bars with hot actions in most of the windows | + | + | ||
| Ability to save all program settings | + | + | ||
| Customizable toolbars for all program windows | + | + | ||
| Fully customizable program interface | + | + | ||
| Powerful visual options module | + | + | ||
| Localizable program interface | + | + | ||
| And other useful features | ||||
| Keyboard templates | + | + | ||
| To-do list | + | + | ||
| External tool manager | + | + | ||
