• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Product features

Database Compare Suite supports the following database server types:

  • Amazon Redshift

  • Azure SQL Database

  • Azure SQL Data Warehouse

  • Greenplum 4.3.8.0 or later

  • IBM DB2 9.7 or later

  • IBM Netezza 7.2.1 or later

  • Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016 (all editions)

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

  • Oracle 9.2 or later

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

  • Sybase ASE 12.5 or later

  • Sybase IQ 16 or later

  • Teradata 14 or later

  • Vertica 7.0 or later

Database Compare Suite supports the following types of database providers:

  • Amazon Redshift – only ODBC

  • Sybase – ODBC and OLE DB

  • All others – only OLE DB

Database Compare Suite allows you to compare, synchronize and migrate data objects.

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 SQL queries:

  • Custom SQL queries

  • User-friendly management of operation preferences

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