Database Compare Suite™

Product features

Supported platforms

Database Compare Suite supports the following database server types:

Database Compare Suite 5.3 New Project

  • Apache Cassandra 2.1 or later (see the Limitations section)

  • Amazon DynamoDB (see the Limitations section)

  • Amazon Redshift

  • Azure SQL Database

  • Azure Synapse Analytics

  • BigQuery (see the Limitations section)

  • Greenplum 4.3.8.0 or later

  • IBM DB2 for Linux, Unix and Windows (LUW) 9.7 or later

  • IBM Netezza 7.2.1 or later

  • MariaDB 5.5 or later

  • Microsoft Access

  • Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, all editions of 2019 (see the Limitations section)

  • MySQL 5.5.3 or later (Database Compare Suite works with previous versions as well, but some features can be unavailable)

  • Oracle 9.2 or later

  • PostgreSQL 9.2 or later (Database Compare Suite works with previous versions as well, but some features can be unavailable)

  • Sybase ASE 12.5 or later

  • Sybase IQ 16 or later

  • Teradata 14 or later

  • Vertica 7.0 or later

Supported database providers

Database Compare Suite supports the following types of database providers:

  • Greenplum, Sybase IQ, and Vertica — only ODBC

  • Amazon Redshift and Sybase ASE — ODBC and OLE DB

  • All others — only OLE DB

Supported operations

Database Compare Suite allows you to compare, synchronize and migrate data objects (see the Limitations section to learn more about specific limitations).

In the database comparison section, you can:

  • Compare all types of database objects

  • Verify data migration using fast data comparison operation, which works quite fast on big data sets in data warehouses

  • Filter compared objects by type or select objects manually

  • Compare databases from the command line

  • Customize schema mapping

In the synchronization and migration sections, you can:

  • Automatically group and map objects

  • Exclude objects from synchronization

  • Edit synchronization scripts

  • Synchronize databases from the command line

  • Migrate databases from the command line

  • Generate comparison and synchronization reports

  • Track changes in databases during the processes

Also, Database Compare Suite supports the following features for Data management and executing SQL queries:

  • Running custom SQL queries

  • User-friendly management of operation preferences

  • Handy tree-view control to display the database schema and the results of the operation

Limitations

  • Amazon DynamoDB, Apache Cassandra, and BigQuery cannot be used as a source for data migration and data synchronization operations

  • Amazon DynamoDB does not support schema operations

  • Database settings comparison is supported only for a pair of Microsoft SQL Server databases


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].