CODEWITHSUNDEEP
sql-servervisual-sourcesafedatabase-versioning
Tushar Maru
Tushar Maru

Reputation: 3435

Can I integrate SourceSafe / VSS with SQL Server 2005?

How are the SQL objects managed with VSS?

Can I integrate SourceSafe / VSS with SQL Server 2005?

I want versioning in my SQL schemas.

Upvotes: 0

Views: 628

Answers (3)

David Atkinson
David Atkinson

Reputation: 5909

We've just added Visual Source Safe support to SQL Source Control, providing source control integrated into SQL Server Management Studio. This is in early access at the moment so please sign up for the early access build and tell us what you think.

More detail is available here: http://www.red-gate.com/MessageBoard/viewtopic.php?t=12265

Upvotes: 0

Roman
Roman

Reputation: 1227

Utilize tools like SQL Compare from Red Gate which will allow you to create schema, object per file, and then maintain the state of the files with VSS. I am currently trying to push that in my organization.

Upvotes: 1

ninesided
ninesided

Reputation: 23273

Aside from VSS being a total train wreck, if you want to store your schema in source control, one possible approach is to store the object creation script for each database object as a separate file in source control. That way, you can update individual parts of the schema easily. So you have a script for each table, trigger, index, procedure etc. As part of your build process these can be pulled together into a single script for ease of application to the target database.

Upvotes: 1

Related Questions