We are happy to announce the latest release of DB Best’s in-house tool Database Compare Suite. The new version marked 4.10 brings support for yet another data warehouse platform — Sybase IQ. Watch Database Compare Suite in action in the following video and learn more about other improvements of the latest update from our blog post.
13 Major Database Platforms and counting
The support of Sybase IQ increases the total number of available database platforms in the Database Compare Suite to 13. This amazing number includes six data warehouse platforms. Moreover, in the following release, we’re planning to add support for yet another data warehouse platform.
The full list of supported database dialects includes Amazon Redshift, Azure SQL Data Warehouse, Azure SQL Database, Greenplum, IBM DB2, IBM Netezza, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase ASE, Sybase IQ, and Teradata. That means now you can use 91 database pairs for schema and data migration, synchronization and comparison.
Paying additional attention to data warehouses, Database Compare Suite developers simultaneously improved specific functions related to big data operations. One of the most important data warehouse operations is the Fast Data Comparison. It allows users to perform an exceptionally fast check whether data in two selected tables is equal or not. We’ve enhanced this operation by adding an option for fast processing of floating numbers.
The problem is that each database platform stores data in its own specific format. This becomes even more significant when we talk about the float numbers. The number of stored digits after the decimal point or the rounding settings may differ. So, when we need to compare the float numbers in two tables stored on various database platforms, we need to be fairly sure that the specifics of storing would not affect the comparison results. The latest release of Database Compare Suite allows interpreting the float numbers as integers or converting them to exponential format. This approach can level the differences of data storage in various platforms. Please take care of the floating point comparison option when performing a heterogeneous data comparison operation.
With huge amounts of data in data warehouses, the data migration operations may last for a long time. It is essential that during the data migration operation, no one changes the options in the target table. With that in mind, we’ve added an option which allows users to lock the target table during a data migration operation. You can check it in the appropriate settings page.
Download our free trial with no strings attached on the Database Compare Suite page.