Supported Databases

This chapter contains the list of databases supported by SQLWays. Source databases are those from which the database structure and data are converted. Target databases are those to which the migrated database structure and data are imported.

Source databases supported by SQLWays are as follows:

TABLE 2. Supported Source databases

Database Product	Version
IBM DB2 for Linux, Unix and Windows	8.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
IBM DB2 for z/OS, OS/390 and MVS	8.1, 7.1, 6.1, 5.2, 5.1 and 4.1
IBM DB2 for iSeries and AS/400	V5R3, V5R2, V5R1, V4R5, V4R4 and earlier
Oracle	10g, 9i, 8i, 8.0.x and 7.x
Microsoft SQL Server	2000, 7.0 and 6.5
Sybase Adaptive Server Enterprise	12.5.1, 12.5, 12.0, 11.x and earlier
Sybase Adaptive Server Anywhere, Sybase SQL Anywhere	9.0, 8.0.x, 7.0.x, 6.0.x, 5.5 and 5.0
Informix	9.4, 9.3, 9.2, 9.1, 7.3, 7.2, 7.1 and earlier
MySQL	5.0, 4.0.x, 3.23 and earlier
PostgreSQL	7.x and 6.x
SAP DB	7.4, 7.3 and earlier
Pervasive.SQL	v8, 2000 and 7
Microsoft Access	2000, 97, 95 and 2.0
Interbase	7.1, 6.x, 5.x and 4.x
Lotus Notes	6, 5 and earlier
dBase, FoxPro, Excel, Paradox, Gupta SQLBase, Clipper and any other ODBC-compliant database	any version

Target databases supported by SQLWays are as follows:

TABLE 3. Supported Target Databases

Database Product	Version
IBM DB2 for Linux, Unix and Windows	8.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
IBM DB2 for z/OS and OS/390	8.1, 7.1, 6.1, 5.2, 5.1
IBM DB2 for iSeries and AS/400	V5R3, V5R2, V5R1, V4R5, V4R4
Oracle	10g, 9i, 8i and 8.0.x
Microsoft SQL Server	2000, 7.0 and 6.5
Sybase Adaptive Server Enterprise	12.5.1, 12.5, 12.0, 11.x
MySQL	5.0, 4.0.x and 3.23
Pervasive.SQL	v8