×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Does VSS support SQL Server

Does VSS support SQL Server

Does VSS support SQL Server

(OP)
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

RE: Does VSS support SQL Server

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

RE: Does VSS support SQL Server

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
 
 
 

RE: Does VSS support SQL Server

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 ?

RE: Does VSS support SQL Server

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
 
 
 

RE: Does VSS support SQL Server

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.

RE: Does VSS support SQL Server

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

RE: Does VSS support SQL Server

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

RE: Does VSS support SQL Server

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?

RE: Does VSS support SQL Server


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...

RE: Does VSS support SQL Server

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close