SQDR System Requirements

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

  • Windows 7
  • Windows Server 2003 or Server 2008
  • Windows Vista
  • Windows XP Professional or Home Edition
  • Windows 2000 Professional or Server

The Data Replicator requires a control database in which to store definitions for sources, destinations, and subscriptions. If you do not already have a SQL Server installation, you can obtain the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) or SQL Server 2005 or 2008 Express free of charge from http://www.microsoft.com/downloads to use as a control database for the Data Replicator.

If you are using Windows Server 2003, Windows XP or Windows 2000, you may use one of the following for the SQDR control database:

  • SQL Server 2000 Desktop Engine (MSDE 2000) Release A, or MSDE 2000 SP3a or SP4
  • SQL Server 2000 with SP3a or SP4
  • SQL Server 2005 (including Express Edition)
  • SQL Server 2008 (including Express Edition)

If you are using Windows 7, Windows Vista or Windows Server 2008, you should use one of the following for the SQDR control database:

  • SQL Server 2005 sp3 or later (including Express Edition)
  • SQL Server 2008 (including Express Edition)

NOTE Note that SQL Server 2005 and 2008 Express do not include the SQL Server Agent component, which is what allows SQDR subscriptions to run automatically. Use the MSDE 2000 version, or one of the full SQL Server products, for the SQDR control database if you want to schedule subscriptions to run automatically.

NOTE To use SQL Server 2008 or SQL Server 2008 Express Edition for the control database, install SQL-DMO, which is one of the Backward Compatibility components of the SQL Server 2008 Feature Pack.

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

  • DB2 for OS/390 and z/OS v5.1 and later (including DB2 9 for z/OS)
  • DB2 for i (formerly known as DB2/400, DB2 UDB for iSeries, and DB2 for i5/OS) running OS/400 V3R2 and later (including DB2 for i v7r1)
  • DB2 Universal Database (UDB) v6.x and later for UNIX and Windows (including DB2 UDB v9.7)
  • SQL/DS (DB2 for VM & VSE) v3.3 and later (including DB2 for VM & VSE v7.5)
  • SQL Server 2008
  • SQL Server 2005
  • SQL Server 2000 Desktop Engine (MSDE 2000) Release A, or MSDE 2000 SP3a or SP4
  • SQL Server 2000 with SP3a or SP4
  • SQL Server v7.0 with at least SP1 (v7.00.699), although SP4 or the current service pack is recommended
  • Oracle 8i or later (including Oracle 11i)
  • MySQL 4.1 or later
  • Informix: any version of Informix supported by v3.50 of the IBM Informix ODBC driver:

IBM Informix Dynamic Server Enterprise or Express Edition 10.0, 11.10, 11.50
IBM Informix Extended Parallel Server 8.50 and higher
IBM Informix SE 7.25
IBM Informix OnLine 5.20 and higher

Incremental replication is supported from OS/400 v5r2 and later using SQDR Plus for iSeries, and from DB2 UDB for Linux, UNIX, and Windows v8.2 and later using SQDR Plus for DB2 UDB. SQDR Plus is licensed separately from the base SQDR product. SQDR 3.60 and later requires the use of SQDR Plus 3.60 or later.

Access to DB2 databases requires an ODBC driver, such as the StarQuest StarSQL driver (v5.53 or later), the IBM DB2 Connect driver, or the IBM iSeries Access for Windows driver (for access to data sources on the OS/400).

Access to Oracle databases requires the Oracle Client software, including the ODBC driver from either Oracle or Microsoft.

Access to MySQL databases requires Connector/ODBC 5.1.5; do not use Connector/ODBC 5.1.6. Specify use of ANSI_QUOTES in the MySQL database configuration if the Quote SQL Identifiers option is enabled for the SQDR service.

Access to Informix databases requires that the database be configured to support Transactions. The database must use the "Delimited" environment variable if the Quote SQL Identifiers option is enabled for the SQDR service.

In addition, you can use Data Replicator with other databases if they can be accessed through an ODBC driver that complies with Level 2 of the ODBC 3.51 specification.

If you use an ODBC driver other than StarSQL there may be additional configuration requirements to use the driver for replications with SQDR. The SQDR Readme file and the Customer Support area of the StarQuest Web site provide details about known issues for using SQDR with other products.