What we can doOur Products CatalogOur SolutionsOrderSupportCompany
EMS SQL Manager™ for InterBase/Firebird
administration and development



Features
EMS SQL Manager™ for InterBase/Firebird - administration and development

EMS SQL Manager 2005 for InterBase/Firebird is a high-performance graphical tool for InterBase and Firebird administration and object management.Its easy-to-use graphical interface and a lot of features will make your work with InterBase and Firebird as easy as it can be!

pricing starts from $135,00

Overview | Features | Screenshots | Reviews | Requirements | Ordering and Licensing | Downloads | Ask a Question | Report a Problem

Features Overview

Latest InterBase and Firebird versions support

  • 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
  • Saving all 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
  • 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 InterBase/Firebird objects

  • Creating/dropping databases and schemas
  • Managing tables and all their subobjects: fields, indices, checks and foreign keys
  • Managing views, triggers 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

Effective security management

  • Powerful user manager for administering users and privileges
  • Grant manager displaying all database object grants in the 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 code completion and syntax highlight
  • Large script executing (SQL script editor)
  • Viewing query execution plans
  • Ability to view query plan as diagram
  • SQL Formatter (Available from SQL Editor context menu)

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 database objects: accessing reports directly through DB Explorer tree

Impressive data export and import capabilities

  • 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

  • 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 tool
  • Creating/editing/dropping tables and table fields, visually setting links between them
  • Saving as image or printing database diagram
  • Two diagram notations (IDEF1x and IE)
  • A lot of visual customization options

Easy-to-use wizards performing InterBase and Firebird services

  • Backing up database
  • Restoring database
  • Database validation
  • Database statistics
  • Bringing database online
  • Shutting down 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


SQL Diagrams.
This application gives you a graphical overview of your SQL Server database solution, it visualizes all relationships between all database objects. .

Read more

DB tools recommendations.
Where is a requirement, there also is a tool that meets that requirement. Let us find you a perfect tool!

Read more

Database Solutions.
If you have a problem or you are in a need of a cost-effective IT solution for your business, we are here to help.

Read more