Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-02-04 : 14:45:23
|
| GreetingsI have been trying to get our IT manager to buy VSS for version control. Pretty much wild wild west here with different people changing SQL objects directly on the sql server. sometimes mistakenly on production server. security is not a big issue in this place.do you have any suggestion on how I can do version control within SQL or any other way you suggest. Is there a sproc yuo have seen around that will script out all the SQL objects to .sql files with DROp CREATE details in the header?Thanks |
|
|
Itamar
Starting Member
19 Posts |
Posted - 2009-05-08 : 10:11:27
|
| You can it with a tool for SQL Version Control.------Nob Hill Software - Tools for Database PeopleSQL Version Control, Database Compare, Query Tools and more. www.nobhillsoft.com |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-08 : 10:43:53
|
| You can also do it with SQL Management Studio, it has options to include IF EXISTS DROP. It also has support to do source control with VSS, and with a plugin, Team Foundation System source control. |
|
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2009-05-08 : 10:54:45
|
| If you are looking at VSS also look at Vault, we moved from VSS to VAULT http://www.sourcegear.com/vault/ (although I understand the latest version of VSS is better than it was) |
|
|
|
|
|
|
Version Control