Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Every administrators, developers have their own collection of scripts (some patterns). Time to time they are dismissed from one job and they are employed to other one. Is there any good, easy used, indexed tool to collect the common used sql scripts (structured folder/file system as a default)?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

I started to play with RedGate's tool - Script Manager. You can have them together in a single place with some UI. It may worth a try :).

share|improve this answer
1  
it looks good, are you using it? is it good enough? –  garik Mar 9 '11 at 13:03
    
For me it's nice enough :). Didn't use it for long.. just one two weeks of play, but looks solid enough. –  Marian Mar 10 '11 at 6:01
add comment

In SQL*Plus, the Oracle command line too, you can use the syntax:

SQL> @http://blah.com/myscript.sql

And run all your scripts off your own personal webserver if you like. My good friend Vishal does this. You just need to get a VM or something of your own, these are cheap now, a quick Google shows £10/month.

Just be certain it doesn't stipulate in your contract that your employer owns any scripts you write while working for them...

share|improve this answer
    
..and employer owns your life. :) I meant so scripts like attach/ detach database, move database...reindex, common optimization scripts...NO any employer specific code. –  garik Mar 9 '11 at 11:23
    
@igor: just added a link to a friend of mine who I learned this technique from –  Gaius Mar 9 '11 at 11:46
    
as a variant...to store on own website (increases web site traffic + good enough storage) thanks! it is a good idea: knowledge sharing. –  garik Mar 9 '11 at 12:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.