What's new in Database Comparer for InterBase and Firebird 4.2.1 Build 51879
Oct 19, 2018- Support for Firebird 3.0 added, minor fixes in SQL Script editor and other fixes...
New in Database Comparer for InterBase and Firebird 4.0 (Aug 28, 2014)
- Significantly improved algorithm of object comparison and script generation.
- Now it is possible to search and analyze renamed objects. Application analyses databases and returns a list of objects that could have been renamed.
- Project Wizard is added.
- The list of object properties to compare is enlarged, which makes it possible to get the more complete analysis.
- Significantly improved work with the object dependencies.
- Added support of new Windows 7, Microsoft Windows 8/8.1 features: progress bar at a task pane and Jump List with project list.
- Improved work with data types.
- Correct comparison of constraints with the server generated names.
- Comparison of object comments.
- Improved comparison of procedure bodies, views and triggers.
- Improved comparison of fields, domains and parameters of functions and procedures taking into consideration field charsets and default database charsets.
- Added comparison of expression indices.
- Added comparison of field autoincrement.
- Implemented processing of circular object dependencies.
- Lots of other improvements and bug-fixes.
New in Database Comparer for InterBase and Firebird 3.3 (Nov 30, 2011)
- Unicode support is added.
- Firebird 2.1 support is added.
- Added the possibility to compare FEDERATED tables (MySQL).
- Added the possibility to connect through the Connection string (Oracle).
- Added the option to exclude the DEFINER parameter when comparing procedures (MySQL).
- Now the CREATE OR REPLACE statement is used to modify objects (PostgreSQL).
- Primary keys with system names are now synchronized correctly (SQL Server).
- The “Load last passwords for new projects” function sometimes loaded wrong passwords. Fixed now.
- Other minor fixes and improvements.
New in Database Comparer for InterBase and Firebird 3.2 (Nov 30, 2011)
- PostgreSQL 8.3 support is implemented.
- Indexes with automatically generated names used to be compared improperly. Fixed now. (SQL Server)
- Scripts to add the AUTO_INCREMENT field into a table which already contained a primary key were generated improperly. Fixed now. (MySQL)
- The possibility to compare invalid and broken objects is implemented. (Oracle, MySQL)
- Database comparison speed is considerably increased.
- Other minor fixes and improvements.
New in Database Comparer for InterBase and Firebird 3.1 (Nov 30, 2011)
- When comparing a Firebird 2.0 database with the one on the Firebird 2.1, identical views used to be marked as different. Fixed now. (InterBase)
- When comparing a MySQL 4.1 database with the one on MySQL 5.0, identical table fields of INT type used to be treated as different. Fixed now. (MySQL)
- The rules were skipped when creating views. Fixed now. (PostgreSQL)
- Partition Functions used to be generated before the Partition Schemes were created. Fixed now. (SQL Server)
- The modifying script used to be generated twice for domains with different size of type. Fixed now. (InterBase)
- The functions with DECIMAL parameters different in dimension used to be compared improperly. Fixed now. (SQL Server)
- When synchronizing constraints stored at servers of 2000 and 2005 versions, the Default value for SQL Server 2005 used to be generated in double parentheses (e.g. ((1))). Fixed now. (SQL Server)
- When comparing an SQL Server 2000 database with the one on SQL Server 2000, identical UDFs used to be marked as different. Fixed now. (SQL Server)
- When comparing databases on Chinese Windows localization, the “Error: RichEdit line insertion error” message used to appear. Fixed now
- Other minor fixes and improvements
New in Database Comparer for InterBase and Firebird 3.0 (Nov 30, 2011)
- Major improvements in comparing engine, now comparing process uses object dependencies information. The synchronization process needs much fewer manual operations.
- Redesign of User interface:
- New improved object tree
- Added grouping schemas in object tree
- Added Object Properties Viewer showing differences in objects visually
- One-click report for databases differences.
- Now the application is more friendly and easy in use.
- Utility source code significantly optimized, work speed increased. Databases comparison is much faster now.
- Now the schema vs schema comparison is available. You can compare and synchronize schemas of different databases as well as on a single database (for PostgreSQL, SQL Server, Oracle).
- Advanced filtering capabilities when selecting objects to compare/ synchronize. Now you can exclude separate objects or object groups from comparison and synchronization.
- New improved SQL Editor:
- Transaction management ability
- Detailed error messages
- Easy focusing on error statements
- Added code completion feature
- Improved SSH Tunneling: (for MySQL, PostgreSQL, InterBase/Firebird, Oracle)
- Added SSH private key authentication
- Separate SSH connections to different servers
- Advanced synchronization is easier and faster.
- Ability to save and print reports of databases differences. You can use built-in reports or create your own.
- Latest SQL server version support.
- Other bug-fixes and improvements.