New in DB Zipper 2.0.0 (Nov 28, 2012)
- Performance improvements: Archiving/backing up data up to 50% faster than before.
- Performance improvements: Unpacking archived data is up to 30% faster than before.
- Added support for command-line options.
- Added support for large archive files.
- Added support for large data sets.
- Added schema/owner support.
- Improved data type conversions when extracting data and table structure to a database platform which is different than the original source database. This improved data type conversion is a result of the introduction of data type conversion rules. These rules are editable and are stored in .dcr files (definitions directory).
- More detailed error messages for the archive table process.
- New extract option: Use value in archive for autonumber columns.
- New extract option: Create comments.
- In the Add tables wizard you can now double click on a table name to move the table between the list with available tables and the list with tables to archive.
- Added support for MS Access 2003 and MS Access 2007.
- Improved PostgreSQL 8 data type support.
- Added support for Oracle function based indexes.
- Added support for PostgreSQL index expressions (only in PostgreSQL 8).
- Fixed a problem with capturing index columns for unique indexes in Oracle.
- Fixed a bug with case sensitivity of column names in Oracle.
- Empty string values were converted to NULL values. This will now work correct but different depending on the database you are extracting to.
- NULL values where converting dates to 1899-12-31. They will now stay NULL.
- Size and Packed columns in work area displayed wrong value when table contained binary fields. Fixed.
- Access violation when you archived and extracted tables in one session. Fixed.
- Progress indicator sometimes gave the wrong percentage. Fixed.
- Fixed a problem with wrong length of RAW fields when extracting to Oracle databases.
- Fixed a problem with failed connection to an Oracle database when adding tables to an existing database archive file.
- Columns that are part of a self-referencing relationship were not added to the database archive file. Fixed.
- Added support for a sort option on index column level for MS SQL Server 2005 and Oracle databases.
- Oracle Not Null constraint names are captured now when archiving tables.
- MySQL 5 column descriptions are imported now.
- MySQL 5 column collations settings are imported now.
- Added support for MySQL 5 charactersets on column level.
- PostgreSQL column descriptions are imported now.
- Index columns for Oracle unique descending indexes were missing (index expression issue). Fixed.
- Added MS SQL Server 2005 column collation support.
- Fixed bug for oracle reverse engineering, TIMESTAMP type is not changed into VARCHAR2 anymore
- Fixed bug for oracle length of NCHAR and NVARCHAR data types. Length imported was twice the correct length.
- When retrieving Tables from MS-Access, it will not include the views anymore.
- For MS SQL Server, fields with data type TIMESTAMP never get populated.
- When converting to another database platform, the following are property values are removed: Collate, Character sets, Table Options, Index Options and Index Expressions.
- Included support for MySQL's YEAR datatype
- Included support for Oracle's BINARY_FLOAT, BINARY_DOUBLE, ROWID and UROWID data types.
- Included support for MS SQL Server's SYSNAME, UNIQUEIDENTIFIER, SQLVARIANT, TIMESTAMP and XML data types.
- Solved problem logging into MS Access database with database password.
- Unidirectional queries implemented for MS SQL Server, Oracle and MySQL.
- Records can now be inserted/updated if the column name contains spaces.
- Fixed a bug when creating Firebird tables with BLOB SUB_TYPE data type.
- When importing indexes for InterBase and Firebird they were always indicated as unique. Fixed.
- When capturing MS Access tables, columns with certain characters in the name (like the minus sign) were not captured. Fixed.
- Fixed problems for table names with mixed case.
- Fixed problem with MS SQL Server 2005 Identity property in combination with multiple schemas in one databases.
- Improved BLOB insertions for all supported databases.
- Fixed problems connecting to MS SQL Server and MS Access databases on some Windows Vista systems.
- Fixed a bug in the Manage database connections dialog. The cancel button still applied the changes.
- Faster loading of application under Vista.
- Fixed file association (.dbz) for Windows Vista in the setup program.