Re: Re: Writing a parser

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 :( thanks for the infos, pa