Does VSS support SQL Server 1

[essa2000]

Dear ;
AOA
I want to know that Does VSS Support SQL Server. I want to place my Stored Procedures in VSS and check out in SQL Server.

Essa2000

 

[TomasDill]

You cannot do this directly in SQL Server 7.0. But you can make a backup of database and than check ing that file in VSS. Don't know if SQL Server 2000 have such feature...

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[kathryn]

Essa,

Are you still interested in this? We are storing SQL sp's in VSS and it is working well. It's a bit round about; actually we store *.sql scripts that delete the current stored procedure, and then recreate it. Any modifications are made to the recreation piece.

Let me know if you are interested or need more info.

Kathryn Kathryn

 

[holdenweb]

I was wondering why, in SQL Server 7.0, I see system stored procedures with names like dt_addtosourcecontrol when there doesn't appear to be any VSS integration.

Has anyone used these procedures, or can tell us what they are intended to do (besides confuse the user ?

 

[kathryn]

Good question. I have just jumped over to the MS KB and found a KB article, "HOWTO: Put Stored Procedures Under Source Control in Visual InterDev" KB # 201240

which might answer some of your questions. However, I cannot find anything on those particular stored procedures, which I have also always been curious about. Kathryn

 

[Guest_imported]

I made a tool: SQLCodeControl (I include the source code, it's free).

You must see ZonaVB:

http://www.geocities.com/zonavb/index.htm

Then, section "Programas" and finally you got the tool: SQLCodeControl.

 

[gbh338]

Hi Kathryn,
I hope you're still reading this thread. I am investigating ways in which we can version control our stored procedures - I would prefer not to use the Visual InterDev method as not all our developers use it. Could you please email some more information about your solutiuon - I have investigated storing them as *.sql scripts, checking them out, altering via query analyzer, then checking them back in - just wondering what advice/experience/issues you could help with.

Thanks,
Mark Grieve
mgrieve@commander.com.au

 

[Guest_imported]

http://support.microsoft.com/support/kb/articles/Q199/2/04.ASP

Can someone help me implementing this SQL Server - SourceSafe integration using Visaul Interdev?

I tried but I just don't get the menu item saying "Add to Source Control".

- Jags

 

[stubey]

Hi,

If you use Visual interdev you can control stored procedures through VSS.
What we do is seperate all our sp's into files and then we can use Visual interdev and VSS to store them and promote to sql server

 

[pauldef]

Does anyone know of a bug or problem using VSS with SQL Server 2000? We want to integrate our source control with Visual InterDev, but we are finding that it doesn't work with 2000 and it does work with 7.0. Any thoughts?

 

[Guest_imported]

Hi Stubey,

Thanks for your reply.

Can you please be more specific about how you exactly promote stored procedures to sql server using VSS and Interdev?

Thanks

- Jags...

 

[Calen]

Does anyone know if the procedure in "HOWTO: Put Stored Procedures Under Source Control in Visual InterDev"
MSKB # 201240
(

http://support.microsoft.com/default.aspx?scid=kb;EN-US;201240)

will work for SQL Server 2000?

Thanks

Calen

 

[jhein]

Kathryn,

I would be very interested in what you have done with regards to putting sp's into SourceSafe. The client I am currently working for has requested this, and we are just about to dig into this one. If you get this message, please feel free to contact me at jhein@slga.gov.sk.ca so we can discuss what you had to do.


Thanks,
Jason