|
Full Version |
Lite Version (free) |
Connection
SQL Server and Windows authentification
Network protocols and other options |
x
x
|
x
x |
Databases
System, Snapshot and User databases
List
Create, delete, rename
Properties, Permissions, Extended Properties |
x
x
x
x |
x
x
x (properties only) |
Tables
System and User tables
List
Create, delete, rename, modify
View dependencies
Quick data edit
Export data to XLS, XML, CSV
Properties, Permissions, Extended Properties |
x
x
x
x
x
x
x |
x
x
x
x
x (properties only) |
Columns
List
Create, delete, rename, modify
Properties, Permissions, Extended Properties |
x
x
x |
x
x (properties only) |
Keys
Foreign and primary keys list
Create, delete, rename, modify |
x
x |
x
|
Constraints
List
Create, delete, rename
Properties, Extended Properties |
x
x
x |
x
x (properties only) |
Triggers
List
Create, delete, rename, modify
View dependencies
Extended Properties |
x
x
x
x |
x
x
|
Indexes
List
Create, delete, rename
Properties, Extended Properties |
x
x
x |
x
x (properties only) |
Statistics
List
Create, delete
Properties |
x
x
x |
x
x (properties only) |
Views
System and User views
List
Create, delete, rename, modify
View dependencies
Export data to XLS, XML, CSV
Properties, Permissions, Extended Properties
Columns, Triggers, Indexes, Statistics |
x
x
x
x
x
x
x
|
x
x
x
x (properties only)
x |
Synonyms
List
Create, delete
Properties, Permissions, Extended Properties |
x
x
x |
x
x (properties only) |
Stored Procedures
System and User stored procedures
List
Create, delete, rename, modify
View dependencies
Properties, Permissions, Extended Properties
Parameters list |
x
x
x
x
x
x |
x
x
x
x (properties only)
x |
Functions
System and User table-valued functions
System and User scalar-valued functions
List
Create, delete, rename, modify
View dependencies
Properties, Permissions, Extended Properties
Parameters list |
x
x
x
x
x
x
x |
x
x
x
x
x (properties only)
x |
Database Triggers
List
Create, delete, modify
Extended Properties |
x
x
x |
x
|
Assemblies
List
Delete |
x
x |
x
|
Types
System data types, User-defined data types, User-defined types, XML schema collections
List
Create, delete, rename, modify
View dependencies
Properties, Extended Properties |
x
x
x
x
x |
x
x
x
x (properties only) |
Rules
List
Create, delete
View dependencies
Properties, Extended Properties |
x
x
x
x |
x
x
x (properties only) |
Defaults
List
Create, delete
View dependencies
Properties, Extended Properties |
x
x
x
x |
x
x
x (properties only) |
Service Broker
Message types, Contracts, Queues, Services, Routes, Remote Service Binding
List
Delete |
x
x
x |
x
x
|
Storage
Full Text Catalog, Partition Schemes, Partition Functions
List
Create, Modify, Delete |
x
x
x |
x
x
|
Users
List
Create, delete, rename
Properties, Extended Properties |
x
x
x |
x
|
Roles
Database roles, Application roles
List
Create, delete, modify
Properties, Extended Properties |
x
x
x
x |
x
x
|
Schemas
List
Create, delete, modify
Properties, Permissions, Extended Properties |
x
x
x |
x
|
Symetric and Asymetric Keys
List
Delete
Properties |
x
x
x |
x
|
Certificates
List
Delete
Properties |
x
x
x |
x
|
Logins
List
Create, delete, modify
Properties |
x
x
x |
x
|
Server roles
List
Properties |
x
x |
x
x |
Credentials
List
Delete
Properties |
x
x
x |
x
x |
Backup devices
List
Create, delete
Properties |
x
x
x
|
x
x |
Linked servers
List
Delete
Properties |
x
x
x |
x
|
Server Triggers
List
Create, delete, modify |
x
x |
x
|
Activity monitor
Process List |
x |
|
Tools and wizards
New query tool
Generate INSERT script wizard
CSV Import wizard
Backup wizard
Restore wizard
Detach wizard
Attach wizard
Shrink database wizard
Change password wizard |
x
x
x
x
x
x
x
x
x |
x
|
Preferences
Multi language
Multi skin |
x
x |
x
x |
Misc.
Ability to enable/disable each feature
Ability to get the T-SQL script of each action
Silent logon module
and much more ! |
x
x
x
x |
x
x
x |