Re: Re: Writing a parser

<paj@pearfr.org> wrote : > On Wed, 10 Jul 2002 10:29:27 +0200 > "Lukas Smith" <smith@dybnet.de> wrote: >>> afaik mdb reverse engineering does not work with sql files, or ? >> >> correct. >> ATM MDB's reverse engineering (which is pretty much just taken from the >> current Metabase betas) needs an existing MySQL DB to extract the >> schema/data. >> >> Manuel is still thinking about how to do it best and I don't have much >> time to invest into this either. > > And I completly agreed with Manuel, about this point. > > >> The basic idea is to provide an interactive app where I can specify the >> source (either a running DB or an SQL source file). The user is then >> asked how to resolve any ambiguity and will get some warnings like >> TIMESTAMP in MySQL will be converted to DATETIME and will therefore >> behave differently. >> If anyone would step up and write this I would be most pleased. > > As I told you before, I m working actually on this kind of tools. > > I was just confused after the manual post and doubt about my capacity to > understand your code ;)). > > Before send you the test codes, I just need an oracle or Ms SQL DB structure > dump, to be sure there is no special syntax (syntax not keywords or options); > I actually do not have an access to these BD :( Try : http://demo.phporacleadmin.org/ It is a running oracle DB with a PHP frontend. Good Luck Bertrand Mansion Mamasam