Lots of static data to link
I have between 50 and 100 tables containing static data (I know...it's a lot) that I need to version in SQL Source Control. The trouble is, those tables exist in about 40 databases across our servers. I would like to avoid manually selecting so many tables so many times through the GUI.
Is there a back door way to accomplish this? Maybe on the file system using SVN and/or modifying Red Gate SSC files? I have a developer here who's quite good at programmatically manipulating files, so we can work with just a little hint...