sql comparison tools

[Kiwi]

Hi,

We've got a bunch of fairly long and complex sql statements that we need to compare between our dev and prd environments. The dev environment has been changed by a bunch of patches, while prd has been changed by an incompetent BA. Does anyone know of any tools that can help do this? Standard text/file comparison tools haven't been any help, so we're down to eyeballing them, which is both no fun and prone to error...

Any suggestion would be gratefully received.

Thanks.

[firepages]

I cant imagine what tool could be much more useful than diff or a variant of , short of one with a bit of syntax highlighting , perhaps pass output of diff to a script for such ? sorry not a lot of help I know... in other words, I don't know of one :confused:

[Kiwi]

We did it the old-fashioned way. If I were even remotely competent with regex, that would have done the trick but, sadly, I'm not.

There's probably a regex (or set of regex) around for parsing SQL as well -- but it's not necessary now. At least, not for me.

Thanks anyway.