Online Documentation for SQL Manager for InterBase/Firebird
Feature Matrix
The FREE Lite version of SQL Manager for InterBase/Firebird does not include all features of the Full version and has some limitations concerning the number of the databases that can be registered and the set of data manipulation and server maintenance tools. The detailed feature matrix is given below.
Note that when using the FREE Lite version of SQL Manager for InterBase/Firebird you can activate a 30-day period of fully-functional usage. After the period expires, you will be able to continue using the Lite version.
For more information on activating the Full version features see Full Mode activation.
| Full version | Lite version | |||
|---|---|---|---|---|
| Latest InterBase and Firebird versions support | ||||
| Compatible with any Firebird server version up to 5.0 | + | + | ||
| Compatible with any InterBase server version up to 2020 | + | + | ||
| Compatible with Red Database | + | + | ||
| 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 | + | + | ||
| 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 | + | + | ||
| Grouping/Ungrouping registered databases by host name | + | + | ||
| Easy management of all InterBase/Firebird objects | ||||
| Creating/dropping databases | + | + | ||
| 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 | + | - | ||
| Open Ofiice documents support | + | - | ||
| 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 | + | - | ||
| Start/Stop database | + | - | ||
| Rebuild indices | + | - | ||
| 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 | + | - | ||
| Search in metadata | + | - | ||
| 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 | + | + | ||
