0

How are the SQL objects managed with VSS?

Can I integrate SourceSafe / VSS with SQL Server 2005?

I want versioning in my SQL schemas.

Montag451
  • 1,168
  • 3
  • 14
  • 30
Tushar Maru
  • 3,347
  • 10
  • 34
  • 53

3 Answers3

1

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.

Roman
  • 1,177
  • 1
  • 17
  • 25
1

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.

ninesided
  • 23,085
  • 14
  • 83
  • 107
  • Total train wreck: my experience as well. – rpetrich Aug 25 '09 at 01:50
  • Although this approach works, it quickly becomes a maintenance hazard, as you need to keep up with the changes. Think of it as an additional task. – SoftwareGeek Feb 17 '10 at 18:11
  • @Wisdom if you have some stringent QA processes in place, it doesn't need to be a hazard, but I'd love to hear of a better approach if you have one! – ninesided Feb 18 '10 at 10:54
  • @ninesided: agreed but my point is that one needs to be very careful & remember to script every change or else you will have versionitis, u know what i mean. – SoftwareGeek Feb 18 '10 at 16:58
  • @Wisdom: I know exactly what you mean ;-) – ninesided Feb 18 '10 at 17:48
  • @BhejaFry That's why you don't let developers make changes in a production environment - this can enforce all changes go through source control. – Rowland Shaw Apr 29 '10 at 11:10
0

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

David Atkinson
  • 5,759
  • 2
  • 28
  • 35