Have Geek Brain

Can SourceSafe / VSS be integrated with SQL Server 2005?

How are SQL objects managed with VSS?

Can SourceSafe / VSS be integrated with SQL Server 2005?

I want to be versioning in my SQL schemas.

0


a source to share


3 answers


Aside from being a total train loss VSS, if you want to keep your schema in the original control, one possible approach is to keep the script object creation for each database object as a separate file in the original control. This way, you can easily update individual parts of the diagram. This way you have a script for every table, trigger, index, procedure, etc. As part of the build process, they can be combined into one script for convenience of application to the target database.



+1


a source


Use tools like SQL Compare from Red Gate, which will let you create schema, object per file, and then save the state of the files using VSS. I am currently trying to do this in my organization.



+1


a source


We've just added Visual Source Safe support for SQL Source Control by providing source code integration into SQL Server Management Studio. This is in Early Access at the moment, so please register for Early Access and let us know what you think.

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

0


a source






More articles:


All Articles