SQL Server Management Studio 2005 and Source Control

Question

I have all my SQL stored in source control in the following structure

Database
    Tables
    Stored Procs
    Views
    Static Data

I'd like to tie my source control into SSMS, which seemingly supports source control, but SSMS wants to put all the scripts into one folder, which is a non-starter for me.

Is it possible to get SSMS to work my existing structure? If not, is SSMS 2008 a bit more flexible in that respect?

Answer 1

You could use SQLDMO (obsolete) to script them out or SMO to do it. Or a third party tool like Apex SQL Script with some automation.