SQL Server Management Studio 2005 and version control

Question

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

Database
    Tables
    Stored Procs
    Views
    Static Data

I would like to associate my original control with SSMS, which seems to support initial control, but SSMS wants to put all the scripts in one folder, which for me is not a starter.

Is it possible to get SSMS to work with my existing framework? If not, is SSMS 2008 more flexible in this regard?

Answer 1

Visual Studio Database Project ( VS 2005 Professional). Visual Studio, ! sql-. , "" Script. . , F5 SSMS, .

http://blog.reamped.net/post/2008/05/Using-Database-Projects-for-Visual-Studio.aspx.

Answer 2

SQLDMO () script SMO . , Apex SQL Script .

Answer 3

Red Gate SSMS, SQL Source Control. , - , . , .