XML Based Progress Database Migration Library

The current version of pro2xmlschema is 1.0.7 as of 20th October 2004. Note that pro2xmlschema is distributed as part of xPollinate. Look in the /progress directory in the xPollinate distribution.

Overview

A database-independent method of converting data from PROGRESS databases. Based on the highly successful ADODB database extraction layer for PHP, and the XMLSCHEMA sub-project, this new project expands the concept of PRO2MY, and using database independant XML based schema and data files, allows the direct conversion of data and schemas inside PROGRESS databases to open source databases such as MySQL, Postgres, Firebird, SQLite, as well as commercial databases such as Oracle, IBM DB2 and Microsoft SQL server.
The programs take care of all aspects of the data conversion, such as appropriate conversion of data types, as well as building a copy of the data dictionary in the new database to allow cross-referencing. The project should ease the pain of data conversion, as well as allowing the easy building of data warehousing and archival applications. The project supports PROGRESS version 9 databases and higher.

• Produces an XML format schema dump ready to be directly imported into one of the supported databases
• Produces an XML format data dump ready to be directly imported into one of the supported databases
• The download files contain all the necessary programs to do the data conversions. You need to install PHP in order to load the data into the target database.

The program suite is base tested using the PROGRESS sports2000 database. In addition, it has been successfully tested loading 500,000 records into IBM DB2 and Oracle 10 databases.

Prerequisites

The PROGRESS programs in this suite are distributed as unencrypted source code. In order to use them, you must have a Version 9 PROGRESS 4GL development license installed on the machine you are using them on.
You must have PHP version 4.3 or higher installed on the machine from which you want to load the database. Pro2XMLschema uses the CLI (Command Line Interface) functions of PHP. You do not need to have a running web server to use them. If you are running on windows the most recent version 4 builds of PHP have the php.exe in the \cli subdirectory. If you are building PHP under Linux/Unix, ensure that you build the cli module. These programs are not yet qualified for PHP version 5.

Target Databases

The software has been tested against the following databases SQLite

Database	Current Status	Information
MySQL	Schema,Data and dictionary convert correctly. Tested by the author.
Schema,Data and dictionary convert correctly. Tested by the author.
SQL Server 2000	Schema,Data and dictionary convert correctly. Tested by the author.
Oracle 8/9/10	Schema, Data and dictionary convert correctly. Tested by the author.
IBM DB2	Schema Data and dictionary convert correctly .Tested by the author.
Postgresql	Schema Data and dictionary convert correctly .

The following databases are in the compatibility list, but have not yest been tested

• Microsoft Access
• Microsoft FoxPro
• Interbase/Firebird
• Informix
• SapDB (MySQL Max)
• Sybase

Licensing

The software is distributed under the terms of the BSD license. You may use the software in any way you choose compatible with the licensing model