Issue with identifying scripts within a repository

[Jeeva Sarma]

Hi

I have a problem, pls see if anyone can give any
suggestions how to go about it.

We have a repository to store scripts which are run
against databases. When the developers check-in the
scripts, no one knows if that will go all the way to
prod. It has to pass qc, or may have some other
issues, so everything that is checked in may not go to
prod. 
All approved scripts will run once in 2 months.So we
need a way to identify all these scripts from the
others in the repository.Pls note that the number of
these scripts is very high. 

One approach is to modify the log message each time a
script is approved, so we can query them and check out
only those that they need to run finally. The problem
with this is it may be too much work.

Another approach is to check in the approved scripts
into another repository or folder so we can easily
pull out those. This is obviously duplicating the
scripts. 

Can anyone suggest any other solution? Hope I was able
to accurately describe the issue.

Thanks .
Jeeva


                
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com