EMS logo

Products Navigation

SQL Studio for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Management Studio for InterBase/Firebird

Features Matrix

  SQL Manager
(full version)
SQL Studio
Basic features
Compatible with any InterBase server version up to XE7
+
+
Compatible with any Firebird server version up to 3.0
+
+
Simple management of all InterBase/Firebird objects (including create/edit/ drop operations)
+
+
Easy-to-work integrated environment uniting all SQL Studio capabilities
-
+
DB registration and connection
Multiple host/database connections
+
+
Connection to InterBase/Firebird Server through SSH
+
+
Registering selected hosts to work with
+
+
Registering selected databases to work with
+
+
Grouping/Ungrouping registered databases by host name
+
+
Single repository for all hosts and DBs registered with EMS Software Development applications.
-
+
DB management
Back Up any registered database
+
+
Restore previously backed up database
+
+
Database statistics
+
+
Database validation
+
+
Shutdown database/Bring database online
+
+
Powerful user manager to administer users and 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
+
+
Powerful and easy-to-use graphical user interface
Office and Windows native visual schemes support
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Localizable program interface
+
+
Keyboard templates
+
+