I've been a bit buried lately with Sarbanes-Oxley requirements. In the last couple of weeks I've written new company policies on Data Integrity and Whistleblowing, as part of the effort to get everything documented by December 15.
One of the other requirements was to get all our production databases documented. This can be a daunting task, but fortunately the new Visual Studio Team System for Database Professionals (Data Dude) came out. I spent two solid days last week pointing Data Dude to each of my production databases and created a Database Project for each one. Because the database project is coded as a set of .sql files it qualifies as valid documentation under our Sarbanes-Oxley guidelines. I added all these projects to our source control system and that requirement is satisfied, and so am I.
Thanks to everybody on the Data Dude team for making my job easier!
Allen