×
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

SQL Server 2000 and VSS

SQL Server 2000 and VSS

SQL Server 2000 and VSS

(OP)
Morning Folk...

  I am interested in any info on how to setup/maintain SQL Server 2000 objects/scripts/triggers and such in VSS. I have read the thread, which is about a year old, on the attempts to integrate SQL Server 7, but found no real “beef” dealing w/ SS2K. Has anyone attempted this as of late? Would anyone know of a good place to visit for some info on this subject? Have a great day!


Thanks

J. Kusch

RE: SQL Server 2000 and VSS

The way I do it is using the scripting feature in sql2000.  You can script everything from Enterprise Manager. You can do this by right clicking the DB and selecting New Task..Generate SQL Scripts. From here check off what you want to script, ie. the "all stored proceedures" box. Now click the options tab and select to script the keys and object level permissions. Also tell it to create one file per object. Then copy the files created into VSS. When you make changes to a proc, check out of VSS, redo this for the specific procs, and check it back in. To deploy all your proc at once, get the latest of all procs in VSS into a temp folder and use the DOS copy command to copy all procs into one text file, load it into Query Analyzer and run it. It will update all procs to the latest version, or you can simply open the scripted .sql file in QA and run it.

Hope that helps.

Mike

RE: SQL Server 2000 and VSS

(OP)
Thanks ... i am fully aware on that part of the fence. what i am looking for is a method to do this for me through an automated task(s). Here is my senerio. I have over 80 DBs that are worked on by all areas of our company. The programmers have a tendency to create scripts, tables, views, triggers ... and not use VSS in some cases, though some do. at a predetermined time ... say sunday night at 12:00am i wanted a script(s) or app(s) to script out all of these items, i need in VSS, to pre-defined directories that i can then sync up w/ VSS. Thanks for the input and if you have a method to accomplish this hurdle, please advise. have a great week!

Thanks

J. Kusch

RE: SQL Server 2000 and VSS

Hmm..  I have not heard of such a app or script that could accomplish this, however it would be a godsend.  Where I am we have 4 servers dedicated to SQL2000 server, all of which have anywhere from 15 to 30 DBs.  If you find of some script that can do this let me know!

Mike

RE: SQL Server 2000 and VSS

(OP)
looking at using sql-DMO as a possibility!

Thanks

J. Kusch

RE: SQL Server 2000 and VSS

I have been Evaluating Embarcadero's Rapid SQL, this work well with SQL2k and VSS 6.0. I can't handle DTS objects.

RE: SQL Server 2000 and VSS

Have you tried looking at mssqlXpress? It handles Stored Procs, Views, Triggers and Tables. www.xpressapps.com

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