DB Best announces the release of a new version of an ultimate DBA tool Database Compare Suite. The latest version supports Amazon DynamoDB. This is the second NoSQL database platform supported by DB Best Database Compare Suite to complement the recent addition of support of Apache Cassandra as a source and target.
In addition to this, Database Compare Suite update 4.14 brings the ability to use SSL to connect to Microsoft SQL Server and Oracle databases. Continue reading to learn more about the other improvements of the Database Compare Suite.
The support for Amazon DynamoDB
You can compare data between Amazon DynamoDB and any other supported database platform. Currently, Database Compare Suite supports 16 database platforms. Be sure to check the official Database Compare Suite 4.14 product page to see the full list of supported databases.
The schema operations are available only for a pair of Amazon DynamoDB databases.
Amazon DynamoDB limitations
Database Compare Suite does not support Amazon DynamoDB tables with composite partition key. That is because we utilize the standard .NET provider to access the data in Amazon DynamoDB. However, we plan to change this approach in the upcoming versions, so that you can operate with tables with composite partition key.
Other limitations include:
- You can’t use Amazon DynamoDB as the source for data migration or synchronization
- Database Compare Suite uses all columns of the Amazon DynamoDB database, even if these columns are not displayed in the metadata tree of the application
- Amazon DynamoDB schema includes only columns of keys and indexes
Database Compare Suite 4.14 provides users with the ability to use SSL to establish a secure connection to Microsoft SQL Server and Oracle databases. In addition to that, you can now specify whether the driver can trust the server certificate when connecting to the Microsoft SQL Server database using TLS.
Also, we updated the setting of the schema operations. With this release, you can ignore column default values and parameter default values in schema operations. Finally, Database Compare Suite now works correctly with an abstract SET data type.
Be sure to check the release history page to learn more about other bug fixes and improvements.
Database Compare Suite proves to be 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.