Shell Programming and Scripting

Hi All,

I am just looking for CVS automation for SQL scripts. Normally Devs will check in new sql scripts or they will update the existing sql scripts with new query. We will take the scripts from CVS and run in DB. I am thinking to automate that process like whenever a new script is checked in or an existing script has modified, the script will run against the DB. The script should poll CVS at a regular interval. Please give some suggestion on it how can i do this.

Thanks,
Mani

Maybe it doesn't have to poll the CVS, but rather you can set bot a post-check-in-routine that runs when a script is changed and in a certain state. In this case, it would be event driven and not by timer.