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 |
|
Andraax
Aged Yak Warrior
790 Posts |
 Posted - 2002-10-02 : 10:11:01
|
| Hi!I'm currently using Visual Source Safe the "manual" way when it come to my database objects. Do any of you use some other tool which can handle things more automatically? Is Visual Studio.NET an option for this?Regards,Kalle Dahlberg |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-02 : 12:09:57
|
Ken Henderson has some details on integrating Source Safe with Query Analyzer inThe Guru's Guide to SQL Server Stored Procedures, XML, and HTMLBasically it's some command-line options that are registered on the Tools menu that allow you to check scripts in and out of VSS, add a new project to VSS, etc. They're pretty simple but they do the job well. Of course there is A LOT MORE to his book than source control  I don't have VS.Net but I don't think it has dramatically better integration with Source Safe, and you really don't need anything spectacular. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-10-02 : 13:40:56
|
| Visual Studio.net has a "Data Project" which allows you to keep a set of change scripts for each of your objects. I didn't care for how it worked.It sorta works like this from what I can tell:Original Stored Proc-->Change Script 1-->Change Script 2-->Current Proc.I think some folks will like that, but I didn't. There didn't seem to be any way to have one script that gave you the current proc. You had to run them all in order so to speak.I'll stick with good old QA and EM for now.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-10-03 : 16:00:25
|
| Thanks guys... And Rob, I have that book already (and the other guru book). I'm just looking for a way for the "lazy" developers like myself :)Well I guess I'll just have to do it the hard way.Regards,Kalle Dahlberg |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-03 : 16:07:28
|
| Source Safe has a COM library, you might be able to program an add-in that extends the functionality. I know VB6 accepted user-written add-ins. |
|
|
|
|
|
|
Source control