Re: MDB: reverse engineer schema

Lukas Smith wrote:

From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Thursday, March 20, 2003 1:36 PM To: Lukas Smith Subject: Re: [PEAR] MDB: reverse engineer schema Lukas Smith wrote:

The problem with reverse engineering of schema files is that it is

not

1-to-1. That is in same cases it is impossible to automatically guess what type to use. For example a CHAR(1) in mysql may be a TEXT(1) or a BOOLEAN. Therefore the manager tries a best guess and issues the other alternatives as a warning. If you want the alternative you have to manually do it.

Okay, so how do I accomplish that? How do I get it to actually create the XML file?

If you get the warnings then you already have the file. The script you are using is pretty simplistic so iirc it just writes the file to the same dir as the script itself. So look in your PEAR MDB dir ($pear_dir/MDB/MDB/) I entered /tmp/dump.sql in the form and indeed it has created that file. My problem it's 0 bytes. I tried looking for some clues inside Manager.php, but did not find anything yet. I'll have closer look though...

Thanks, Jeroen