Welcome to SQL Manager 2005 for InterBase/Firebird!
EMS SQL Manager 2005 for InterBase/Firebird is a powerful tool for InterBase/Firebird Server administration and development. It provides an easy-to-use graphical interface for maintaining databases and database objects, managing table data, building SQL queries, administering users and their privileges, extracting, printing, and searching metadata, etc. SQL Manager 2005 for InterBase/Firebird has a lot of unique features, such as: SP Debugger, Visual Query Builder, Export Data to 15 available formats and Import Data from most popular formats, BLOB Viewer/Editor, SQL Script processor and many more… SQL Manager 2005 for InterBase/Firebird has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
EMS SQL Manager for InterBase and Firebird 2005
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 and 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 and 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 and group 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 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 and Firebird services
Backup database
Restore database
Database Validation
Database Statistics
Bring database online
Shutdown database
Other useful tools to make your work with InterBase and 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
