May 25, 2005, 8:31 AM
Post #1 of 1
I have a bunch of patches to my database, and each patch is a .sql file. Unfortunately, I wasn't originally explicitly noting which objects were affected by each patch, and I need to go back and determine that now to see which patches will need to be run on a clean install in order to get the desired performance. I've written a script to go through and search for things like create or replace procedure/tables, and such, but its getting fairly complicated. I've looked for a perl script to parse through it and figure all that out for me, but i haven't found anything.