On Thursday, February 28, 2002, at 03:23 PM, Ken Y. Clark wrote:
> All, > > I have the beginnings of something that might actually be CPAN-worthy: > a translator for converting one database's create syntax into > another's. I had personal need to convert MySQL and Sybase to Oracle, > so I've got the basics of those worked out, and I'm trying to find a > nice way to produce XML. > > Currently, I'm using Parse::RecDescent to parse, and some general > purpose "print" code to produce the output. I'm breaking it into > smaller modules (Parsers and Producers), with the idea being that any > Parser can be used with any Producer in the conversion process. So, > if you wanted PostgreSQL-to-Oracle, you could just write the > PostgreSQL parser and use the existing Oracle producer, so half the > work would be done. > Would it be possible to use DBIx::Renderer as the basis for Producer syntax? It is setup to create CREATE statements in a SQL-independant way... <quote url="http://www.tkdtutor.com";> We do not rise to the level of our expectations. We fall to the level of our training. The more you sweat in training, the less you will bleed in battle. - Motto of Navy Seals </quote>
