System Requirements

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

• Windows Server 2003
• 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. You can use any of the following editions of SQL Server for the SQDR control database.

• SQL Server 2000 Desktop Engine (MSDE 2000) Release A, or MSDE 2000 SP3a
• SQL Server 2000 with SP3a
• SQL Server 2005
• SQL Server 2005 Express can be used as control database, with limitations (scheduling not available).

If you do not already have a SQL Server installation, you can obtain the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) free of charge from www.microsoft.com/downloads (search for MSDE) to use as a control database for the Data Replicator. The SQDR Technical Document Installing SQL Server 2000 for a Control Database provides more information.

You can replicate data to and from any of the following database systems:

• DB2 for OS/390 v5.1 and later
• DB2/400 (DB2 UDB for iSeries) OS/400 v3r2 and later
• DB2 Universal Database (UDB) v6.x and later for UNIX and Windows
• SQL/DS (DB2 for VM & VSE) v3.3 and later
• SQL Server 2005
• SQL Server 2000 Desktop Engine (MSDE 2000) Release A, or MSDE 2000 SP3a
• SQL Server 2000 with SP3a
• SQL Server v7.0 with at least SP1 (v7.00.699), although SP4 or the current service pack is recommended
• Oracle 8i or later

Access to DB2 databases requires an ODBC driver, such as the StarSQL driver available from StarQuest Ventures, IBM DB2 Connect, or IBM iSeries Access for Windows (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.

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.txt file and the Customer Support area of the StarQuest Web site provide details about known issues for using SQDR with other products.

Incremental replication is supported from OS/400 v5r2 and later, using the separately licensed component SQDR Plus for iSeries.