What's new?

SQL Manager 2005 for InterBase/Firebird

4. 3. 0. 1 - May 31, 2006

What's New in SQL Manager 2005 for InterBase/Firebird?

1.	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 from the external file will be placed into the corresponding fields.

2.	Extract Database Wizard.

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.

3.	DB Explorer. The Add to Projects command is added. Now objects can be added by specifying them in the corresponding dialog, as well as by dragging into Projects folder.

4.	. The ability to view dependencies for the domains that refer to other objects via Check constraints is added, as well as dependencies for the tables that refer to other objects via Check constraints and those 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.

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.

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 English 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 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.