DBMS Notes CompareData

Some of the databases and drivers tested with CompareData.

Basic DBMS metadata support is provided using ODBC catalog functions whereas extended DBMS metadata support provides additional features such as comparing triggers by accessing the DBMS information schema.

DBMS Version Driver Ver Test
SAP Advantage Database Server 12 Advantage StreamlineSQL ODBC 12.00.00.00 Pass64
Birdstep RDM Server 7.0 Birdstep ODBC for RDM Server 7.0 7.00.701.00 Fair
DB2* 11.05 IBM DB2 ODBC Driver - DBCOPY1 11.05.5000.1587 Fail
IBM DB2 ODBC Driver - IBMDBCL1 11.01.3031.368 Pass
DBISAM 4.24 DBISAM 4 ODBC Driver 4.24.00.01 Pass
DBMaker 4.2 DBMaker Driver 4.02.00.4721 Pass
FairCom c-treeSQL Server V8.14 c-treeSQL ODBC Driver 8.24.05.29 Pass
FileMaker Pro 19.2.1 FileMaker ODBC 19.00.05.00 Pass
Firebird* 2.0 Firebird/InterBase(r) driver 2.00.05.156 Pass
FrontBase 4.2 FrontBase ODBC 1.20.00.85 Fair
1.20.00.91 Pass
SAP Hana 4.0.7 HDBODBC 2.04.0171 Pass64
Informix IDS* 14.10 IBM INFORMIX ODBC DRIVER (64-bit) 4.50.00.18020 Pass
Ingres 9.2* 9.2.0 Ingres 9.2 3.50.920.90 Fair
InterBase* 7.5 Firebird/InterBase(r) driver MT 2.00.00.136 Pass
Linter 6.0.8 Linter 6.0 Driver 3.00.61.00 Pass
MaxDB 7.6 SAP DB 7.06.00.00 Pass
Microsoft Access 2003 - 2019 Microsoft Access Driver (*.mdb, *.accdb) 16.00.13328.20334 Pass64
Microsoft Excel 2003 - 2019 Microsoft Excel Driver (*.xls, *.xls,...) 16.00.13328.20334 Pass32/64
Microsoft SQL Server* 2005 - 2019 ODBC Driver 17 for SQL Server 17.06.01.01 Pass64
Mimer SQL 10.01.06 MIMER 10.01.06.01 Pass64
MySQL* 8.0 MySQL ODBC 8 ANSI Driver 08.00.21.00 Pass
OpenLink Virtuoso 4.5 OpenLink Virtuoso (4.5) 4.50.29.04 Fair
Oracle* 19c Oracle in OraDB19Home 19.00.00.00 Fair
DataDirect 8.0 Oracle Wire Protocol 8.00.02.2364 Pass
Pervasive PSQL 9.5 Pervasive ODBC Client Interface 9.50.77.02 Fair
PostgreSQL* 12.0.4 PostgreSQL ODBC Driver(ANSI) 12.02.00.00 Pass
Snowflake 4.43.2 SnowflakeDSIIDriver 2.22.03.00 Pass
SQL Anywhere* 17 Adaptive Server Anywhere 17 17.00.10.6089 Pass
SQLite* 3.32.3 SQLite3 ODBC Driver 0.9998.00.00 Fair
Sybase* 15 DataDirect 5.2 Sybase Wire Protocol 5.20.00.13 Fair
Adaptive Server Enterprise 15.00.00.50 Failed
15.0.0.152 Fair
Text Files - DataDirect 5.2 TextFile (*.*) 5.20.00.20 Pass
Microsoft Text Driver (*.txt; *.csv) 16.00.13328.20334 pass
Teradata V2R5.0 Teradata 3.02.00.02 Fair
Passpass Fairfair/issues Failedfailed/not supported (32-bit, 64-bit)
*Extended metadata support

DB2

IBM DB2 ODBC Driver - DBCOPY1 11.05.5000.1587 Fail
SQL Error. Native Code: 0, SQLState: IM004, Return Code: -1
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Use IBM DB2 ODBC Driver - IBMDBCL1 11.01.3031.368 instead.


DBISAM

DBISAM 4 ODBC Driver 4.24.00.01 Pass

Tables are not listed in a Tables/Views comparison unless Remote Client/Server mode is used to connect to the database.


Firebird

SQL Error, SQLState: 08004, Return Code: -1 [ODBC Firebird Driver]Unavailable Database

Only one application can connect to the the embedded Firebird database at any one time. Note, however, that an application can have multiple connections to the same embedded database as long as all these connections are from the same instance of the application.

Solution: verify that no other applications are connected to the embedded repository database.  You can use Windows Task Manager to scan for cmpdata.exe to ensure that only one instance of the application is connected to the embedded repository.

This error may also be due to another application using the embedded Firebird client (fbclient.dll) or if the database file does not exist.

If you want to have multiple applications connect to CompareData repository database at the same time, then you need to run Firebird as a Server and set up an ODBC data source for the repository database. You can download Firebird server from www.firebirdsql.com

Firebird/InterBase(r) driver 2.00.00.151 Pass

This driver is distributed with CompareData and is used by CompareData to connect to its embedded repository. You can use this driver to compare/synchronize Firebird databases.


FontBase

FrontBase ODBC driver 1.20.00.85 Fair

FrontBase has a fix build for the driver that addresses miscellaneous issues.


Ingres 9.2

Ingres 9.2 3.50.920.90 ODBC Driver Fair

SQLForeignKeys returns rows for another table with the same name as the requested table (but with different owner). Will be fixed in the next release of the Ingres ODBC driver.


MaxDB

SAP DB Driver 7.06.00.00 Pass

Enter password all upper case when setting up application data source or leave password blank to have the driver prompt you for the password.


Oracle

Oracle in OraDB19Home 19.00.00.00 Fair
[Oracle][ODBC][Ora]ORA-24812: character set conversion to or from UCS2 failed

Driver fails to convert from single-byte database character set CLOB data type to unicode database character set CLOB data type, even with driver Force SQL_WCHAR support option checked in the driver ODBC configuration.


Pervasive

PervasiveSQL v9.5 Driver 9.50.77.02 Fair

Sybase

DataDirect 5.1 Sybase Wire Protocol 5.10.00.81 Pass
Return code 100. No Data Found for an Insert Statement

Insert fails with return code 100 on executing an insert statement if the insert statement is a prepared statement and the previous execution of the statement encountered a server error.  Workaround:  in the driver ODBC setup window select 2 - Full for the Prepare Method in the Performance tab.

OpenLink Lite for SQL Server (TDS)(32-bit) 5.20.76.00 Fair

Issue with synchronizing dates. Month part of date gets decremented by 1.  This is fixed in the latest update to the driver.

When setting the ODBC driver enable the No Quoted Identifers option in the driver setup dialog.

DataDirect 5.2 Sybase Wire Protocol 5.20.00.13 Fair
Adaptive Server Enterprise 15.00.00.50 Failed
Adaptive Server Enterprise 15.0.0.152 Fair

Various issues. Until these issues are fixed, it is recommended to use DataDirect Wire driver for Sybase instead.

Extended Metadata Support

In order to get resultset description for triggers and stored procedures/functions you must set the 'Enable Dynamic Prepare' option for the ODBC data source (Connection tab in the driver set up dialog)


Text Files

Microsoft Text Driver (*.txt; *.csv)pass

Please see schema.ini for information about setting up text driver.

[Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only.

Driver does not allow text file names without extension or file extension is not allowed by default Q245407