Hi
What good, but simple solutions are there for implementing version controll
of all my SQL scripts? I currently use SSMS do handle all my
scripting/querying.

/Andy.l

MRWildiac (MRWildiac (AT) discussions (DOT) microsoft.com) writes:
Well, you could use any version-control tool you are comfortable.
Version control of SQL scripts is no different from version-controlling
anything else.

If you want something integrated, you can get it with Visual SourceSafe.
Reg Gate has a SQL Source Control, currently in beta, which integrates
with a more version-control systems, for instance Subversion.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Another option is Visual Studio Team Edition, which includes Team Foundation
Server for source control. With VSTS, the SQL is conceptually more like
source code than scripts. The source code can be used to build a new
database from scratch or upgrade an existing one to the source-controlled
version. I would call this more of an Enterprise solution than a simple
one, though.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/