Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: SQL Parsing

by pboin (Deacon)
on Feb 24, 2006 at 13:04 UTC ( #532524=note: print w/replies, xml ) Need Help??


in reply to SQL Parsing

Would you care to expand on *why* you want to do this? Your question is short on detail.

To a certain extent, you're running pretty close to the old "only perl can parse Perl" example. The only thing that's likely to reliably and perfectly parse the more advanced and obscure bits of your particular dialect of SQL would be the SQL engine from your DB of choice.

I just have a feeling that if you explain more, some monk might come up with a creative way to help you that you might not expect...

Replies are listed 'Best First'.
Re^2: SQL Parsing
by Anonymous Monk on Feb 24, 2006 at 16:44 UTC
    The situation here is like this... The SQL generated by a set of reports need to be parsed in order to obtain the metadata. The reports are hitting a database of type 'A'.The metadata obtained after parsing the SQL will be used to identify the table structures that need to be created in a database of type 'B' so that the reports can be migrated to 'B'. The only good thing is that both 'A' and 'B' support SQL. The reports are my only source of information about 'A'

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://532524]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2021-07-30 17:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?