EMS SQL Manager for InterBase/Firebird

Version history

 

Full version history is available at http://sqlmanager.net/en/products/ibfb/manager/news.

 

 

       Version 5.0 - January 25, 2008

 

1. Full InterBase 2007 and Firebird 2.1 support, including DB triggers, journaling and incremental backup.
2. Support of UTF8 data in SQL Editor, Query Builder, Grid View, Data Export/Data Import wizards.
3. Now you can continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder or while table or view data are being loaded to the editor. A query taking too long to execute can be aborted.
4. All Wizards, including Data Export/Data Import, DB Extract and Services wizard can now be run in the background mode, so that you could continue working with the program.
5. New improved SQL Editor of the Visual Studio 2005 kind with Code Folding function and UNICODE support.
6. Improved Data Import Wizard now allows importing data up to 10 times faster. New import formats have been added: HTML, XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007).
7. Improved Data Export Wizard now works faster. New export formats have been added: XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007)
8. Improved Extract DB Wizard works faster; now it also considers all object dependencies and allows defining the server version to generate the script for.
9. Common SQL commands can now be generated from DB Explorer (Script to SQL Editor, Script to Clipboard). Now you can easily generate such SQL commands as CREATE, ALTER, DROP, SELECT etc. for each database object.
10. Now you can save your queries in the Favourite Queries folders in DB Explorer; these queries can be stored either locally in the registry (nobody but you will have access to them) or in a special database table (then all or some of your db users will have access to it).
11. Improved Visual database designer, new objects like comments and virtual relationship added. Now it is possible to include Procedures, Functions and Views in the diagram. One can choose whether only object names or also fields and parameters should be displayed.
12. Dependency tree tool can now be run in the background mode, so that you could continue working with the program.
13. Viewing database statistics ability extended. Now you can analyze temporary system tables (must be supported by server).
14. Grid View improved. Now the data of a sublevel of the Master or Detail table linked with the current table by a foreign key can be displayed automatically.
15. The ability to switch between the visual and non-visual modes in trigger, view and procedure editor is implemented.
16. External plugin interface is restored.
17. Firebird database alias file support implemented.
18. Improved Procedure debugger with the Call Stack feature implemented. Now you can navigate your embedded calls of stored procedures easily.
19. Improved Table Editor. Now like in other object editors the scripts that are connected with the changes made at the Editor window are accumulated and can then be executed at a time during compilation. A user can also select the scripts to be executed.
20. The options added that allow the relevant services stop, start and open a database automatically.
21. The Find option function is added to SQL Manager settings form as well as to the database and host registration info forms.
22. The Recompute All service has been added which allows rebuild all database indices (or just selected ones) or recalculate their statistics.
23. The search for an object in DB Explorer is enhanced. Now you can perform incremental search by names as well as define the search area.
24. For users’ convenience the Windows List function is implemented as a separate DB Explorer tab with the search ability.
25. In DB Explorer hosts are now named in accordance with the selected connection type (SSH tunneling or direct connection).
26. SQL Script. Ability to execute selected statements and statements under cursor added.
27. Improved report building system.
28. Lots of other improvements and bug-fixes.

 

 

       Version 4.4 - November 22, 2006

 

• The option that allows to skip refreshing objects on connection to database is added. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.
• Import of database registration information from the previous version settings of SQL Manager for IB/FB is improved. Local databases are now registered according to the servers which use similar client libraries for connection.
• Embedded database registration has become simpler.
• 'Copy Alias From' option is added in the new database registration dialog.
• It was impossible to register a database when there were no hosts registered. Fixed now.

 

 

• The ability to use one SSH tunnel to establish connection for several hosts/databases at the same time is added.
• Now it's possible to use tunneling for the services.

 

• New Field editor form.
• Now it's possible to fill the NOT NULL fields which have no DEFAULT value set with the data taken from the fields of the table being edited.

 

• The ability to display and edit ARRAY fields is added.
• When editing data or deleting records in a table which contains no unique or primary key, errors often occurred (the changes were not applied). Fixed now.
• It was impossible to edit a BLOB type field in Detail Level. Fixed now.

 

 

• The ARRAY type data can be saved to an external file now.
• An option is added which allows to extract metadata of the objects on which the current object depends.
• The object dependency handling is improved.

 

 

 

 

• A script can now be executed from cursor; execution of the selected fragment is also possible.
• String comments (beginning with '--') are recognized correctly now.
• The ARRAY type data can now be imported from an external file when executing SET BLOBFILE statement.

 

• When performing input for the DECIMAL and NUMERIC type parameters the decimal delimiter used to change with the localization applied. Fixed now.
• The value of the empty string was treated as NULL. Fixed now.
• The FIRST statement is recognized correctly now.

 

 

 

 

 

 

 

       Version 4.3 - May 31, 2006

 

• Now you can specify DBMS server for which the script should be generated.
• Now it's possible to export BLOB field content into an external file with the ability to compress data. When executing the result script the data from the external file will be placed into the corresponding fields.

 

• To avoid errors during script execution the 'computed by' fields are moved to the end of table fields list; then their position is restored.
• Now it's possible to export BLOB field content into an external file with the ability to compress data. When executing the result script the data from the external file will be placed into the corresponding fields.

 

 

 

• The 'Expand All' and 'Collapse All' context menu items added.
• The 'Save column sorting' option is added for the 'Save and restore layout' mode

 

 

• For the queries which allow data insert the ability to import data into the table implemented.
• The Ctrl+Shift+Enter shortcut for pointing out the corresponding item in DB Explorer tree worked incorrectly. Fixed now.
• Now it's possible to rename and move query tabs
• Query execution time is now displayed in hh:mm:ss format
• 'Select All' command didn't work correctly on text that had very long lines (more than 4096 symbols). Fixed now.

 

 

 

 

 

• Russian localization added.
• Corrections and improvements in German and English localizations.

 

 

 

• Executing DROP DATABASE statement with database name, login and password without having connected to it first.
• Now after dropping a database the Unregister Database dialog appears.
• Handling the AutoDDL mode without SET AUTODDL statement executition.
• When DROP DATABASE and CONNECT statementes are executed without login and password the Login dialog appears.

 

16.        Many other small improvements and bugfixes.

 

 

 

       Version 4.2 - April 4, 2006

 

1. German localization added.

 

2. Editor Options. Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs.

 

 

3. Visual Query Builder. Query execution plan is now displayed as a graphical diagram.

 

4. Dependency Tree. The diagram can now be printed.

 

5. Ability to call Register Database Wizard from SQL Script for the databases created is implemented.

 

6. SQL editors

• Next Bookmark, Previous Bookmark context menu items added.
• In some rare cases, an attempt to use Code Complete tool with 'Trim trailing spaces' option on, cleared all the line  with 'Trim trailing spaces' option on. Fixed  now.
• Dragging the field names from SQL Assistant works perfectly now.

 

7. SQL Editor. Abillity to execute statement under cursor added.

 

8. Visual Database Designer. The Drop Table context menu item worked incorrectly if the field, not the table itself, was selected. Fixed now.

 

• Now with the 'Commit changes manually' option switched on at the end of import you will be prompted for an action with transaction.
• Ability to resize wizard's window added.
• On setting format for fields to import, the 'Generator Value' and 'Constant Value' options used to be ignored. Fixed now.
• Having specified user-defined fields to import, the rest of them were filled with empty strings; so that default values defined for the fields were not applied. Fixed now.

 

10. HTML Report. Ability to change header/footer of the report added.

 

11. SQL Script. Abort executing script confirmation added.

 

12. DB Explorer. The context menu didn't hide when switching to another application. Fixed now.

 

13. Table Editor. The lines exceeding 32 symbols were truncated when exporting lists of subobjects. Fixed now.

 

14. Procedure Editor and Trigger Editor. Parameters or variables deleted in editor window used to reappear in trigger/procedure body after compilation. Fixed now.

 

15. On attempt to execute a query or procedure with Date, Timestamp, Time typed parameters, the Conversion Error message appeared. Fixed now.

 

16. There were no checks for the type of file when creating a report by import from file, which initiated errors. Fixed now.

 

17. When creating a report its components working with data used only default client library, so that in some rare cases it was impossible to open reports working with the database on a local host. Fixed now.

 

18. Most memory leaks fixed.

 

19. SQL Script. The ability to re-execute the script which finished with errors added.

 

20. When editing the data containing fields with NULL values, changed data used to restore their  previous values after commit. Fixed now.

 

21. Other small improvements and bug fixes.

 

 

 

       Version 4.1 - February 20, 2006

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

       Version 4.0 - January 27, 2006

 

• 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

 

• Office 11 and Windows XP visual schemes support
• New well-described Wizard System
• New useful Navigation Bars in most of the windows
• New Windows Toolbar to switch between windows easily, like in Windows Task Bar

 

• Creating tabs for any tree node to access it in one-click!
• Work with multiple selected objects at a time
• Much more convenient toolbar and context menu

 

• Obvious new look
• Two diagram notations (IDEF1x and IE)
• Improved diagram navigation
• Several pages in one diagram to divide diagram into different subject areas
• A lot of visual customization options

 

• Plenty of useful tools such as data grouping, summarizing, 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
• Fully customizable interface

 

• New procedure and trigger editors with enhanced precompiler
• New view editor with automatic generation of view header and ability to create view using visual query builder
• Quick saving and loading in all database object editors
• Autosaving database object with opportunity to restore on further connection

 

• Possibility of creating queries with unions and subqueries visually
• Ability to view query plans in the form of a diagram

 

• SSH connections support to encrypt client/server communications for increased security (Most suitable in case of Internet connection)

 

• New Create Report Wizard allows you to create simple report in a few clicks

Managing reports in the same way as if they were a database object: accessing reports directly through DB Explorer tree

 

 

 

       Version 3.9.5.1 - September 8, 2005

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

       Version 3.9.0.2 - February 17, 2005

 

 

 

 

 

 

       Version 3.9.0.1 - February 3, 2005

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

       Version 3.8.5.1 - December 7, 2004

 

1. Script Editor. We have added the possibility of executing the construction 'CREATE OR ALTER'.

 

2. Eliminated the error with changing the field type from INTEGER to BIGINT when working with FireBird server.

 

3. Extract Metadata. Disabled generation of SQL statements for indices that correspond to the constraints.

 

4. Extract Metadata. The error with limiting precision to 5 in NUMERIC field types is eliminated.

 

5. Extract Metadata. We have added the showing CHARACTER SET property for input and output parameters of the stored procedures.

 

6. Extract Metadata. Eliminated showing COLLATE and NOT NULL properties for domain-based fields.

 

7. Search in Metadata. Fixed the bug with hanging-up the program on trying to start search with an empty string.

 

8. The 'Access Violation' arose when closing database if the connection to the server was lost. The problem is fixed.

 

9. Main Menu | DataBase | Disconnect from DataBase: now works fine.

 

 

       Version 3.8.0.1 - August 23, 2004

 

 

 

 

 

 

 

7.   DB Explorer/Duplicate Object: fixed a bug that appeared when trying to duplicate an object if the program established connection with two databases at once.

 

8.   Export to Excel: We have added an ability to set values of the defined cells, merge cells, and define the page background

 

 

10.        A bug with displaying and editing bigint fields is fixed.

 

 

       Version 3.7.0.1 - January 19, 2004

 

 

 

 

 

 

 

 

 

 

 

 

               

       Version 3.6.5.1 - September 5, 2003

 

 

 

 

 

 

 

 

 

 

 

 

       Version 3.6.0.1 - July 9, 2003