Blog: Database Compare Suite update 4.13 brings Apache Cassandra support

We’re happy to announce the latest groundbreaking release of DB Best Database Compare Suite. The new version allows for working both with NoSQL and SQL-based databases, comparing data between them. In addition to that, Database Compare Suite update 4.13 brings several important improvements and bug fixes, including:

Database Compare Suite 4.13

Continue reading to discover all of the major improvements implemented in Database Compare Suite 4.13.

The support for Apache Cassandra

Database Compare Suite now brings the support for the first NoSQL platform in its history. We’re talking about the Apache Cassandra database management system. This means that Database Compare Suite now supports 15 database platforms. And this means that with the latest edition of the Database Compare Suite you can “marry” NoSQL databases with SQL-based counterparts and compare data between them! Be sure to check the full list on the official product page.

Connecting to a Cassandra database, you should provide the data consistency level. As you may know, Cassandra stores the data in various replicas. The consistency level specifies the number of replicas, which must respond to a request. Regarding the selected value, Database Compare Suite will write to all replicas of the partition key, even replicas in other data centers.

Database Compare Suite allows for comparing data and schemas between two Cassandra databases. Also, you can compare schemas between Cassandra and Microsoft SQL Server. Moreover, you can use the application to compare data between two Cassandra databases as well as between the Cassandra database and any other relational counterpart, supported by Database Compare Suite. This is how this magic works:

We use the unique partition keys of the Cassandra database and then discover the matching columns in the relational database. Then we use a loop statement to select the data related to the given partition key from the Cassandra database. We also select the data from the relational database. Now we can compare these two data sets, showing the number of equal rows, as well as the number of unequal rows. We include the data from the unmatched partition keys into the unequal rows count.

Searching for database objects

We then added a small but very important Search button at the top right corner of the metadata tree. You can search the database objects of the selected type by name. Please notice that you need to specify the object type to complete the search.

You can choose the object type from the drop-down list. This list includes all the available types for the selected database object. In addition, you can specify the search mode, choosing one of the following options: Partially, Full, or Mask.

Data operations updates

We added a couple of new options in the data operations. They allow for setting up the row limit for data comparison operation or using tolerance in data comparison and detailed data comparison operations.

The Use Row Limit option allows for comparing the specified number of rows from each table. If you leave the Use Row Limit option unchecked, Database Compare Suite will compare all objects.

The Use Tolerance option allows for ignoring the difference between the two decimals. Basically, you can consider 2 numeric values equal if the difference is less than the specified value. Usually, this comes in handy when comparing the data from different databases, which apply different rounding rules to the floating point numbers. You can set the tolerance value to 0.001% or higher.

 

Summing up, the latest version of Database Compare Suite now supports 15 various database platforms. Database Compare Suite 4.13 should be considered a valuable and helpful tool for all DBAs and developers who manage multiple database instances.

 

You can download the free trial version of the application from the Database Compare Suite page.