EMS logo

Products Navigation

SQL Studio for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Management Studio for SQL Server

Features Matrix

  SQL Manager
(full version)		 SQL Studio
Basic features
Support of SQL Server versions from 7.0 to 2005
+
+
Simple management of database objects (including create/edit/drop operations)
+
+
Easy-to-work integrated environment uniting all SQL Studio capabilities
-
+
DB registration and connection
Multiple host/database connections
+
+
Registering selected databases to work with
+
+
Grouping/Ungrouping registered databases by host name
+
+
Single repository for all DBs registered with EMS Software Development applications.
-
+
DB management
Backup any registered database
+
+
Restore previously backed up database
+
+
Manage backup devices
+
+
Configure linked servers
+
+
Executing/importing/exporting DTS packages
+
+
Creating/editing/dropping SQL Server jobs and viewing their history
+
+
Creating/editing/dropping SQL Server alerts
+
+
Creating/editing/dropping SQL Server operators
+
+
Powerful login manager to administer server logins and their privileges
+
+
Grant manager displaying all database object grants in the form of a grid
+
+
Data manipulation
View, edit, search, group, sort, filter any data stored in registered database
+
+
Export data in many formats (MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.)
+
+
Export data stored in different DBs in a single operation
-
+
Import data from many sources (MS Excel, DBF, TXT, CSV, XML, MS Access)
+
+
Import data from different sources to different DBs in a single operation
-
+
Convert database structure and data from OLE DB/ODBC data sources
-
+
Generate test data to several database tables at the same time
-
+
Console versions for all data manipulation utilities
-
+
Data Analysis
DB comparison and synchronization ability
-
+
Data comparison and synchronization ability
-
+
Console versions for all data analysis utilities
-
+
Template management
Create new templates for SQL Studio utilities
-
+
Edit existing templates for SQL Studio utilities
-
+
User friendly template manager. Fast access to the needed template.
-
+
Launch the utility for the selected template in one click
-
+
Scheduler
Scheduled execution of DB service tasks (BackUp, Restore, etc.)
-
+
Scheduled execution of data manipulation tasks (Import, Export, etc.)
-
+
Scheduled execution of any external applications
-
+
Creation and execution of complex tasks
-
+
Storage of logs for executed tasks
-
+
Flexible system of task execution results notifications (e-mail, net send, Application Log)
-
+
Log management
Storage of logs for applications run by Scheduler
-
+
Ability to search, view, delete, export existing logs
-
+
Report designer
New 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
+
+
Other tools
Extracting metadata and data into text files or SQL script editor
+
+
Extracting metadata and data from different DBs in a single operation
-
+
Console version of Extract metadata tool
-
+
Powerful print metadata module for creating customizable metadata reports
+
+
HTML report generator to create a detailed HTML report about your database quickly
+
+
SQL Monitor
+
+
SQL Query
+
+
      Saving favourite queries
-
+
      Saving query history
-
+
      Ability to create diagrams based on queries
-
+
Visual Database Designer
Two diagram notations (IDEF1x and IE)
+
+
Reverse engineering
+
+
Ability to create/edit/drop tables and table fields, visually set links between them
+
+
Saving as image or printing database diagram
+
+
New state-of-the-art graphical user interface
Office 11 and Windows XP visual schemes support
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Localizable program interface
+
+
Keyboard templates
+
+