Author: EMS Database Management Solutions

[See remaining text…] 

1. The comparison and synchronization algorithm is significantly improved and is optimized for working with large databases. The comparison speed is considerably increased, in some cases up to 5 times.
   The synchronization speed is increased, especially in cases when compared tables are located on one server.
2. The amount of the consumed RAM is reduced, now it does not depend on the number of records in compared tables which allows avoiding the Out of Memory error.
3. The speed of auto-fill in tables and fields is increased.
4. Added the possibility to synchronize BLOB fields in InterBase.
5. Added the option for viewing the Summary for the compared objects at the “Results of comparison” step.
6. Synchronization with deleting of records from tables containing foreign keys could result in an error. Fixed now.
7. Added the possibility to clear the template list.
8. Other improvements and bug-fixes

We hope you’ll enjoy working with our software.

« Hide it

[See remaining text…] 

What’s new in Data Export 2007?

1. Unicode support. Now you are able to export Unicode data (from SQL Server, MySQL and PostgreSQL databases).
2. Export to new formats is available now:
   • MS Excel 2007
   • MS Word 2007
   • Open Document Format (Open Document Text and Open Document Spreadsheet)
   • Generic XML with XSD schema
3. Now you can use parameters in data export queries. The parameters are prompted in interactive mode in the wizard. In the Console version query parameters can be set in the command line or prompted in interactive mode.
4. Utility source code significantly optimized, work speed increased.
5. Now you can select destination server (SQL Server, Oracle, MySQL, DB2, etc.) when exporting to SQL format. Result script will be generated in accordance with the specifications of the target server.
6. Wizard window is now resizable.
7. An error used to occur when exporting tables containing VARCHAR fields with the length of more than 255 symbols to MS Access. Fixed now.
8. Other minor improvements and bugfixes. 

You can learn more about EMS Data Export 2007 for InterBase/Firebird at: www.sqlmanager.net/products/ibfb/dataexport

You can purchase EMS Data Export 2007 for InterBase/Firebird at: www.sqlmanager.net/products/ibfb/dataexport/buy

We hope you’ll enjoy working with our products!

« Hide it

[See remaining text…] 

1. Database Registration.
• 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.
2. InterBase 2007 partial support implemented. Now the UTF-8, UNICODE_BE, UNICODE_LE charsets are supported.
3. SSH Tunneling
• 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.
4. Field Editor.
• 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.
5. Data Grid.
   • 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.
6. SQL Reference is available again now. It can be called from object editors.
7. Extract Database
   • 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.
8. Restore Database. Interface improved. Now it’s possible to register the server on which the backup copy will be restored.
9. Export as SQL Script. The ARRAY type data can be saved to an external file now.
10. Duplicate Object. Now when duplicating table data the BLOB and ARRAY type fields can be duplicated.
11. SQL Script.
    • 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.
12. Debugger
    • 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.
13. UDF Editor/BLOB Filter Editor. Now there’s no need to take an object’s dependencies into account when changing its parameters.
14. Procedure Editor. The support of BLOB type parameters for Firebird is implemented.
15. Code Completion. The Code Completion feature is implemented for table aliases.
16. Dependencies/Dependency Tree. When analyzing dependencies the objects referred to in CHECK constraint bodies and COMPUTED BY table fields are now taken into account.
17. Other small improvements and bugfixes.

We hope you’ll enjoy working with our products!

« Hide it