View Single Post
Old February 28 2013, 02:41 PM   #52
Yelp for People
Fleet Admiral
Yelp for People's Avatar
Location: Robert Maxwell's Profile
View Yelp for People's Twitter Profile Send a message via ICQ to Yelp for People Send a message via AIM to Yelp for People Send a message via Windows Live Messenger to Yelp for People Send a message via Yahoo to Yelp for People
Re: What Are You Working On (And How Are You Getting There)?

If no one minds me being a bit more detailed about something work-related (and if you do, skip this post):

We have a bunch of SQL databases with about 10,000 stored procedures. For those who are unfamiliar with such technology, they are programs stored inside the database itself, so they don't exist as external files you can open up and edit. There is currently no version control on them, so it's difficult to know which ones were modified, when, and to what extent. A daily process dumps all of the procedures from each database into text files--one file for each database, so all the procedures are lumped together. Not exactly conducive to figuring out when something is changed, right?

So, I wrote a little program that scans the archive each day, breaks up the files into their constituent procedures, and then commits all the changes to version control. There were some challenges involved since the archive files are not marked up in such a way that it's very easy to determine where each procedure begins and ends, and the name of the procedure is inserted numerous times into the text of the procedure itself (I have no idea why, frankly), so I have to do some massaging and parsing to make it all work correctly. But work, it does! I am pretty happy with it, and it doesn't interfere with anyone else, which is a good thing.

I love automation.
Five stars!
Yelp for People is offline   Reply With Quote