Need to copy Progress DB scheme to MySQL DB

[Delphi]

Hello, I am new to Progress but I have been recently assigned a job to copy a DB schema to MySQL.

I have a Progress 10 Personal Edition DB, and I need to copy the DB schema to MySQL DB. The Progress DB does not support dumping because its the personal edition.

Basically I need to re-create all the table's on the Progress DB to a new MySQL DB.

I was thinking that I can just write program in C# .NET that would connect to the Progress DB and go through every table and make a create script for MySQL.

Is this the right way to go? How do I connect to a Progress DB from C# code? Do I need some special adapters installed?

Whats the best way to do this?

Help is greatly appreciated.

Thank you.

 

[RealHeavyDude]

AFAIK, the Personal Database license will only allow you to start a database server which accepts shared memory connections - no remote ( TCP ) connections. If I am right then there is no way you could connect via ODBC to that databse because an ODBC connection will always need a TCP port to connect to.

You can batch ASCII dump the schema of your database ( Progress format which you would need to convert to SQL format ). But you will always need a developer license at the point where you need to compile your wrapper procedure which calls the Progress dictionary utility:

ID: P10208
Title: "How to perform a batch ASCII dump"
Created: 10/01/2002 Last Modified: 08/21/2003 Status: Unverified


Goals:
How to perform a batch ASCII dump



Facts:
UNIX
Progress 8.x




Fixes:
The programs that the Data Dictionary uses to create .d and .df files are called dump_d.p and dump_df.p and these are located in %DLC/src/prodict.

Create a small program containing the command to run the dump program eg:

run <path_to_file>/dumpd(f).p (+ parameters).
quit.

Then run the program using mbpro eg:

mbpro <databaseName> -p <./yourProgram>

You may want to specify > outputfile or > /dev/null to avoid 516 messages, the files will be still be dumped:

** Attempt to write with no current output destination. (516)

The parameters required for the .df and .d files are detailed in the comments at the top of each program.

Heavy Regards, RealHeavyDude.