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.
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.
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.
The software has been tested against the following databases
Database Current Status Information
MySQL Schema,Data and dictionary convert correctly. Tested by the author. SQLite 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
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