Database Compare Suite™
- Overview
- Product features
- Getting started
- Connecting to server
- Connecting to an Amazon DynamoDB database
- Connecting to an Amazon Redshift database
- Connecting to an Apache Cassandra database
- Connecting to an Azure SQL Database
- Connecting to an Azure Synapse Analytics data warehouse
- Connecting to a BigQuery data warehouse
- Connecting to a Greenplum database
- Connecting to an IBM DB2 database
- Connecting to an IBM Netezza database
- Connecting to a MariaDB database
- Connecting to a Microsoft Access database
- Connecting to a Microsoft SQL Server database
- Connecting to a MySQL database
- Connecting to an Oracle database
- Connecting to a PostgreSQL database
- Connecting to a Snowflake database
- Connecting to a Sybase ASE database
- Connecting to a Sybase IQ database
- Connecting to a Teradata database
- Connecting to a Vertica database
- Installing the required database drivers
- Creating a new project
- Opening an existing project
- Key activation
- User interface elements
- Connecting to server
- Operations in details
- Schema comparison
- Schema synchronization
- Schema operations options
- Data comparison
- Detailed data comparison
- Fast data comparison
- Data synchronization
- Data migration
- Settings comparison
- Virtual views
- Sorting key selection
- Selecting operation scope
- Matching
- Matching rules
- Fast data comparison options
- Data operations options
- Command-line interface
- Settings
- Requirements
- Known issues
- Support
Installing the required database drivers
You must have the required ODBC or OLE DB drivers installed for the Database Compare Suite to connect to the source and target databases. Installing the required database drivers is an important operation that should be completed before you try to connect to Amazon Redshift, Greenplum, IBM DB2, Microsoft Access, Oracle, Sybase ASE, Sybase IQ, and Vertica databases.
You can download the database drivers from the following locations. When in doubt, choose the driver version corresponding to the version of the server, that is used.
| Database Platform | Download link |
|---|---|
| Amazon Redshift | http://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html |
| Greenplum | https://www.postgresql.org/ftp/odbc/versions/msi |
| IBM DB2 | https://www.ibm.com/analytics/us/en/technology/db2/db2-trials.html |
| Microsoft Access | https://www.microsoft.com/en-US/download/details.aspx?id=13255 |
| Oracle | https://www.oracle.com/database/technologies/odac-downloads.html |
| Sybase ASE | https://support.sap.com/software/installations.html |
| Sybase IQ | https://support.sap.com/en/my-support/software-downloads.html |
| Vertica | https://my.vertica.com/download/vertica/client-drivers |
| Other | Other database platforms do not require driver installation. |
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].