EMS SQL Manager for InterBase/Firebird 5.1

EMS SQL Manager for InterBase/Firebird 5.1 is a software designed for InterBase and Firebird database administration and development, which can work with any InterBase and Firebird database management systems version up to the newest one

EMS SQL Manager for InterBase/Firebird supports all of the latest InterBase and Firebird features including DB triggers, journaling, incremental backups, and others. It offers plenty of powerful database tools such as Visual Database Designer to create InterBase/Firebird database in few clicks, Visual Query Builder and Stored Procedure Debugger for InterBase and Firebird SQL scripts development and many more useful features for efficient InterBase/Firebird administration. SQL Manager for InterBase/Firebird has a 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.

Major Features:

1. Latest InterBase and Firebird versions support
   • Compatible with any Firebird server version up to 2.1
   • Compatible with any InterBase server version up to 2009
2. 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 program settings
   • Localizable program interface
3. 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 ones only
   • Project mode for working with the needed database objects only
   • Grouping/ungrouping registered databases by host name
4. Easy management of all InterBase and Firebird objects with Unicode support editors
   • Creating/dropping databases
   • Managing tables and all their subobjects: fields, indices, checks and foreign keys
   • Managing views, triggers, DB triggers and stored procedures
   • Trigger messages support is implemented
   • Managing UDFs, exceptions, generators and BLOB filters
   • Managing journals and journal archives
   • Duplicating all database objects
   • Renaming most of database objects
   • Viewing dependencies between the database objects
   • Powerful stored procedure and trigger debugger
5. Advanced Unicode 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 with Unicode support
6. Effective security management
   • Powerful user and group manager for administering users and privileges
   • Grant manager displaying all database object grants in the form of grid
7. Excellent visual and text tools for query building
   • Visual query builder with Unicode support allowing you to build complicated queries without any knowledge of SQL syntax
   • Multiple Unicode SQL editors with code completion and syntax highlight; executing queries in background mode
   • Large Unicode script executing (SQL script editor)
   • Ability to view query plans in the form of diagram
8. 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
9. Impressive Unicode compatible data export and import wizards working in background mode
   • Exporting data to most popular formats: MS Excel, MS Word (up to version 2007), HTML, PDF, TXT, CSV, DBF, XML, ODS, ODT, etc.
   • Exporting data to MS Access
   • Importing data from MS Excel, DBF, TXT and CSV
   • Importing data from MS Access
10. 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
11. Easy-to-use wizards performing InterBase and Firebird services in background mode
    • Backup database
    • Restore database
    • Database journaling
    • Incremental database backup
    • Database Validation
    • Enhanced database Statistics
    • Bring database online
    • Shutdown database
    • Ability to rebuild or recompute all or some of database indices
12. Other useful tools to make your work with InterBase and Firebird as easy as it can be
    • Extracting metadata in background mode into text files or SQL script editor with Unicode support
    • Powerful print metadata module for creating customizable metadata reports
    • HTML report generator to quickly create a detailed HTML report about your database
    • Report designer for building powerful reports visually
    • SQL Monitor
13. Other useful features
    • Keyboard templates
    • To-do list
    • External tool manager
    • Third-party plugins support

Enhancements:

1. Preliminary support of Firebird version 2.5.
2. Host Registration.
   • The work with embedded servers is improved. Now you don’t need to copy files to the IB/FB Manager root folder, the server can be registered from any folder to which the server archive was unzipped.
   • Improved the Autodetect client library/security database path function.
3. Database Registration.
   • The options are added which allow setting up Data Grid modes for each database.
   • The options concerned with transaction parameters are added to the Database Registration dialog which allows you to set them up for each database.
   • The ‘Sort by primary key’ option is added, which allows sorting data by the primary key on opening the Data Grid.
4. Database Properties
   • The ability to change parameters of the database which is not currently connected is added.
   • Now you are able to set database buffer parameters.
   • Changing of the database dialect was applied only after the program restart. Fixed now.
5. DB Explorer.
   • Context menu items concerned with launching additional server/database/object tools are placed into the Tasks submenu to reduce the context menu size.
   • Now you can call the debugger for procedures, triggers, DB triggers, as well as for Favorite Queries that contain scripts implicating debugging.
   • The button for switching the search mode is added to the toolbar.
   • When renaming a host which had several databases registered on and after restarting the program, the database structure displayed in the DB Explorer used to be incorrect. Fixed now.
6. Table Editor.
   • New Table Editor form.
   • The ability to create external tables is added.
   • The ability to create global temporary tables is added.
   • The file name of the external tables used not to be displayed in the DDL. Fixed now.
7. Procedure/Trigger/DB Trigger Editor.
   • The autocompletion function is implemented for parameters and variables.
   • During the compilation process the precision of all parameters and variables of the NUMERIC(x,y) and DECIMAL(x,y) types used to be reduced to the precision of the first parameter. Fixed now.
   • During the compilation process the NULL default value was lost. Fixed now.
   • Using the WEEK keyword in the script resulted in a precompiler error. Fixed now.
   • On attempt to compile a procedure containing the CREATE OR ALTER PROCEDURE statements the error occurred. Fixed now.
8. Modal Object Editor. The modal editor windows are made resizable for the more convenient work.
9. SQL Editor.
   • The ability to call debugger for scripts that implicate debugging is implemented.
   • The autocompletion function is implemented for parameters and variables of the scripts, procedures, triggers, DB triggers and the EXECUTE BLOCK constructions.
   • Usage of the FIRST keyword in a query resulted in an error. Fixed now.
   • Queries with string comments were not executed. Fixed now.
10. Data Grid.
    • The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid allows to perform simultaneous fetching without losing the ability to use other functions of the program.
    • The synchronous mode now allows using the shared connection for all Data Grids, which is essential for the servers with the limited number of allowed connections and for the work with global temporary tables that remain actual within the connection context.
    • Sorting by primary key is performed optionally now.
11. SQL Monitor. Refreshing a database with the opened SQL Monitor resulted in the program hanging. Fixed now.
12. SQL Script.
    • The ability to execute scripts/procedures/DB triggers without the SET TERM construction is implemented.
    • The errors occurred during the script execution are fixed.
    • In some rare cases the script execution errors were not displayed. Fixed now.
13. Table Altering Monitor is implemented within a separate thread, so that you can take advantages of other program functionalities when working with that tool.
14. Extract Database.
    • DB journals can be extracted now. 
    • Conversion of the script to the selected character encoding occurs now during the extraction and not at the moment of saving to a file which reduces the script generation time.
    • Triggers used to be omitted when extracting the full database. Fixed now.
    • When extracting triggers, some of them were processed with empty bodies. Fixed now.
15. Export as SQL Script. Conversion of the script to the selected charset occurs now during the extraction and not at the moment of saving to a file which reduces the script generation time.
16. Debugger.
    • The ability to debug Favorite Queries that contain scripts implicating debugging is implemented.
    • The Watches tab is added which allows display parameter and variable values from different contexts in one window. 
    • The ability to delete/activate/deactivate all breakpoints at once is implemented.
17. Options.
    • The options concerned with database settings are duplicated/moved to the Database Registration Info form, which allows setting them up for each database separately.
    • The ability to apply default settings (for all or just a separate category of options) is implemented for all option dialogs. 
    • The Templates form is revised. New templates are added.
    • The ability to save object templates is implemented.
    • The Save Options wizard saves data in a separate thread now, so that you can take advantages of other program functionalities when working with that tool (especially useful when many databases are registered).
18. Visual Database Designer.
    • Virtual relations can be renamed now.
    • When opening a saved diagram containing virtual relations, those relations used to change their location as compared to the location at the moment of saving. Fixed now. 
19. Many other small improvements and bugfixes.

Requirements: