• Print this Page

02/15/2010

EMS SQL Manager for InterBase/Firebird version 5.2 released

We are pleased to announce the new minor version of SQL Manager for InterBase/Firebird - the powerful tool for InterBase/Firebird database administration and development!

You can download the new version of the software from the download page.

What's new in SQL Manager for InterBase/Firebird 5.2?

1. Windows 7 support is added.
2. Preliminary support of InterBase 2009 is added.
3. Database Properties. Added the support of Embedded User Authentication (EUA) for InterBase 7.5 and higher.
4. DB Explorer.
   • Added the Embedded User support for InterBase 7.5 and higher. Creating, editing, duplicating, activating/deactivating and deleting of the new object are supported.
   • It is now possible to activate/deactivate the EUA mode for InterBase 7.5 and higher.
   • For Firebird 2.5 it is now possible to create a view from a stored procedure.
   • Connection to a database through the Local protocol was not possible on InterBase Desktop Edition servers. Fixed now.
   • Connection to a host with the NTLM authentication caused an error. Fixed now.
   • It was impossible to connect to the database the path to which contained Unicode characters. Fixed now.
   • The connection to an InterBase database with a client library of version lower than 6.0 caused an error. Fixed now.
   • Upon connecting to the first newly registered host, the list of users was not refreshed. Fixed now.
   • When connecting to a host via SSH tunneling with the passphrase request, it was impossible to enter the passphrase. Fixed now.
5. User Editor / User Manager. Added the possibility to work with Embedded Users for InterBase 7.5 and higher.
6. Role Editor. Added the possibility to add Embedded Users to roles for InterBase 7.5 and higher.
7. Grant Manager / Permissions frame in object editors. Added the possibility to manage object privileges for Embedded Users (for InterBase 7.5 and higher).
8. Extract Database.
   • Added the possibility to extract Embedded Users (for InterBase 7.5 and higher).
   • Data of the NUMERIC type were extracted from Firebird 2.1 databases with the incorrect delimiter. Fixed now.
   • Object names were sorted in the descending order after the extraction. Fixed now.
9. Table Editor.
   • Changed the method of accumulating a script to compile changes made in the editor.
   • Added the possibility to select the editor type (modal or individual) which is opened by double-clicking the trigger.
   • Field descriptions were saved only partially. Fixed now.
10. Procedure/Trigger/DB Trigger Editor.
    • Added the possibility to use Explicit Cursors for Firebird 2.x.
    • Added the possibility to auto-fill cursors.
    • In the Procedure Editor it is now possible to create a view from the stored procedure being edited at the moment.
    • 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.
11. Modal windows of object editors are now resizable for the more convenient work.
12. View Editor.
    • It is now possible to use Common Table Expressions (CTE) for Firebird 2.1 and higher.
    • Added the possibility to select the editor type (modal or individual) which is opened by double-clicking the trigger.
13. SQL Editor.
    • Added the possibility to auto-fill cursors for the Execute Block statement.
    • Added a scrollbar under the Plan tab.
    • Some erroneous queries were executed without any error messages. Fixed now.
    • Inputted parameters were not saved when executing parameterized queries. Fixed now.
    • The Result tab was not displayed in the 'Asynchronous query execution' mode. Fixed now.
    • In some queries the ORDER BY clause was truncated. Fixed now.
14. New keyboard templates are added.
15. Query Builder. After loading a diagram from file, the query was corrupted. Fixed now.
16. Debugger.
    • Debugging an object which contained EXECUTE STATEMENT caused an error. Fixed now.
    • Added the support of procedures with Explicit Cursors.
17. Export as SQL Script. Export of Unicode data was performed incorrectly. Fixed now.
18. Visual Database Designer. The Unicode text was displayed incorrectly in comments. Fixed now.
19. Create Updatable View.
    • The incorrect script was generated for the Before Update trigger. Fixed now.
    • The Compile window did not appear for an invalid script. Fixed now.
20. SQL Monitor. Erroneous statements from SQL Script were not added to the Log. Fixed now.
21. Dependency Tree.
    • Added the possibility to place the selected object to the display area automatically when the Dependency tree is too large.
    • Added the possibility to move the tree within the display area by holding the left mouse button.
    • Changed the drawing of the selected object and recursive objects for better distinction.
    • Added different display modes of Dependency tree: to show all objects, to show objects depending on the Root object, or only objects the Root object depends on.
    • Added the possibility to show/hide domains in the Dependency tree.
22. Environment Options.
    • Added the possibility to specify which database should be selected for a newly opened editor or a newly started service: the database selected in DB Explorer or the one from the currently focused editor.
    • Added the possibility to specify how the editors layout is to be saved: for each particular object or for all objects of one type.
23. Visual Options.
    • Added the possibility to set Slants Kind in the Page controls options.
    • User-defined visual scheme were only applied upon clicking 'Apply' twice. Fixed now.
24. Other minor improvements and bug-fixes.

Hope you will enjoy working with our software.