EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

Product News

06/05/2006
SQL Manager 2005 for InterBase/Firebird ver. 4.3 released

We are pleased to announce new version of SQL Manager 2005 for InterBase/Firebird. You can download the newest version from the download page.

What's new in SQL Manager 2005 for InterBase/Firebird version 4.3?

  1. Export as SQL Script.
    • Export as SQL Script. 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 that contained in the external file will be placed into the corresponding fields.
  2. Extract Database.
    • To avoid errors during script execution the 'computed by' fields are moved to the end of table fields list; then restore their position.
    • 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 that contained in the external file will be placed into the corresponding fields.
  3. DB Explorer. The Add to Projects command is added. Now objects can be added by specifying them in the corresponding dialog, and not only by dragging into Projects folder.
  4. Dependency Tree. The ability to view dependencies for the domains that refer to other objects via Check constraints is added, as well as ones for the tables that refer to other objects via Check constraints and dependecies for the tables that use UDFs in their 'computed by' fields.
  5. Grid.
    • The 'Expand All' and 'Collapse All' context menu items added.
    • The 'Save column sorting' option is added for the 'Save and restore layout' mode
  6. CPU usage significantly decreased.
  7. SQL Editor.
    • Now it's possible to rename and move query tabs.
    • For the queries which allow data insert the ability to import data into the table implemented.
    • Query execution time is now displayed in hh:mm:ss format.
    • The Code Completion tool didn't start automatically. Fixed now.
    • Opening object editor with the Ctrl+Enter shortcut used to ignore its scheme. Fixed now.
    • The Ctrl+Shift+Enter shortcut for pointing out the corresponding item in DB Explorer tree worked incorrectly. Fixed now.
    • 'Select All' command didn't work correctly on text that had very long lines (more than 4096 symbols). Fixed now.
  8. Controls at the toolbars now remain after installing a newer version of the product. To bring them to their default state you can use corresponding command from "Windows" menu or corresponding button in Environment Options dialog.
  9. Data Import wizard. When setting column correspondence for import from Excel, selecting a new column caused cursor to move to the first column in grid. Fixed now.
  10. Database Registration Info. When applying changes, the originality of database aliases used not to be checked. Fixed now.
  11. Visual Database Designer. Switching to another visual scheme didn't take any effect on context menu style. Fixed now.
  12. Localization
    • Russian localization added.
    • Corrections and improvements in German and Eglish localizations.
  13. Shutdown Database and Bring Database Online services are combined together and placed into Start/Stop Database wizard which allows using templates.
  14. Domain Editor. The Collation was not displayed when opening Domain Editor. Fixed now.
  15. SQL Script.
    • Executing DROP DATABASE statement with database name, login and password without a requirement to establish connection with it beforehand.
    • Now after dropping a database the Unregister Database dialog appears.
    • Handling the AutoDDL mode without SET AUTODDL statement executition.
  16. Many other small improvements and bugfixes.

We hope you'll enjoy our products.

twitterfacebook