EMS logo

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Feature Matrix


  Windows Professional Windows Lite
Full support of Firebird 2.0 and InterBase 7.5
Compatible with any Firebird server version up to 2.0
+
+
Compatible with any InterBase server version up to 7.5
+
+
Trigger messages support
+
+
Support of BLOB Filters
+
+
Powerful and easy-to-use graphical user interface
MDI and floating-window styles implementation
+
+
Handy database explorer to manage all InterBase/FireBird objects
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Powerful visual options module
+
+
Possibility of saving all the program settings
+
+
Localizable program interface
+
+
Rapid database management and navigation
Multiple host/database connections
+
+
Connecting via local port forwarding through the SSH tunnel
+
-
Registering/unregistering databases for working with the required databases only
+
+
Project mode to work with the needed database objects only
+
+
Grouping/ungrouping registered databases by host name
+
+
Easy management of all InterBase/FireBird objects
Creating/dropping databases
+
+
Managing tables and all their subobjects: fields, constraints, indices and triggers
+
+
Managing views and stored procedures
+
+
Managing UDFs, exceptions, generators and BLOB filters
+
+
Duplicating all database objects
+
+
Renaming all database objects
+
+
Viewing dependencies between database objects
+
-
Powerful stored procedure debugger
+
-
Advanced data manipulation tools
Powerful BLOB viewer/editor with several types of viewing BLOB data
+
-
Plenty of useful tools such as data grouping, 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
+
-
Ability to copy and paste selected records
+
-
Advanced printing system
+
-
Exporting data to SQL script as INSERT statement
+
-
Powerful security management
Powerful user manager for administering users and privileges
+
+
Grant manager displaying all database object grants in a form of a grid
+
+
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 query parameters, code completion and syntax highlight
+
+
Large script executing (SQL script editor)
+
+
Ability to view query plans in the form of a diagram
+
-
Report designer with clear in use report construction wizard
New Create Report Wizard allows you to create simple reports in a few clicks
+
-
Managing reports the same way as if they were a database object: accessing reports directly trough DB Explorer tree
+
-
Impressive data export and import abilities
Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.
+
-
Exporting data to MS Access
+
-
Importing data from MS Excel, DBF, TXT and CSV
+
-
Importing data from MS Access
+
-
Powerful visual database designer
Possibility to create, edit and drop tables and table fields, set links between tables visually
+
-
Reverse engineering
+
-
Saving as image or printing database diagram
+
-
Easy-to-use wizards performing InterBase/FireBird operations
Backing up database
+
-
Restoring database
+
-
Database validation
+
-
Database statistics
+
-
Bringing database online
+
-
Shutdowning database
+
-
Other useful tools to make your work with InterBase/FireBird 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
+
-
Report designer for building powerful reports visually
+
-
SQL Monitor
+
+
And other useful features
Keyboard templates
+
+
To-do list
+
+
External tool manager
+
+
-


Products Navigation

SQL Manager for IB/FB

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter