Db2 for Linux, UNIX, and Windows v9.7 and laterĪccess to Db2 databases requires an ODBC driver, such as the StarQuest StarSQL driver, the IBM Db2 Connect driver, or the IBM i Access Client Solutions driver (for access to Db2 for i).Īccess to Microsoft SQL Server databases requires the Microsoft ODBC Driver 17 for SQL Server (currently 17.7).Īccess to Oracle databases requires one of the following ODBC drivers:.

SQDR Plus is licensed separately from the base SQDR product: Incremental replication is supported from the following databases using SQDR Plus.

Informix: any version of Informix supported by v4.70 of the IBM Informix ODBC driver:.

Amazon Relational Database Service (RDS) for MySQL 5.6 or later.

Oracle 10g or later (including Oracle 19c).

IBM Db2 for z/OS 8.1 and later (including Db2 12 for z/OS).

IBM Db2 9.7 & later for Linux, UNIX and Windows (including Db2 LUW 11.5).

IBM Db2 for i (formerly known as DB2/400, DB2 UDB for iSeries, and DB2 for i5/OS) running OS/400 V5R4 and later (including IBM i 7.4).

Using SQDR, you can replicate data to and from any of the following database systems:

For SQL Server control database: ODBC Driver 17 for SQL Server.

For Db2 for LUW control database: StarQuest StarSQL (included in the SQDR installer).

For a remote database, install the appropriate ODBC driver: The control database can be either local or remote.

SQL Server 2012 through 2019, including Express Edition.

Similarly, you can obtain the Microsoft SQL Server Express free of charge from to use as a control database for the Data Replicator. You can obtain Db2 Community Edition free of charge from IBM.

Otherwise, you can use any of the following versions of IBM Db2 for Linux, Unix Windows (LUW) or Microsoft SQL Server for the SQDR control database.

If you are using SQDR Plus to support incremental replication, we recommend using the instance of Db2 LUW installed with SQDR Plus.

The Data Replicator requires a control database in which to store definitions for sources, destinations, and subscriptions.

Windows Server 2012R2, 2016, 2019, 2022Ī minimum screen resolution of 1024 x 768 is recommended when using Data Replicator Manager.

You can install and run the StarQuest Data Replicator (SQDR) software on any of the following operating systems:

Star start sql server 2016 express