enterprise change control?
Here at work we are looking for a solution to what's probably a pretty common problem. In an nutshell, we do all our application support in three environments -- Development, Test/Staging, and Production. All initial work is done in Dev, which generally has no data or a very limited set of data. Dev is used just to get whatever it is you are working on to compile, if you will. Test is where the actual testing is done in a quasi-production environment with a relatively recent snapshot of production data. Then, of course, production is where all the users do their everyday work. Pretty standard stuff.
What the systems administrators want to do is take away the ability of we reckless developers to put things into production. As if our stuff is not 100% perfect by the time we are ready to go to production! The nerve! They want to control it so that we notify them that a change is ready to be made, and then they want to perform the change (copying executables, config files, report files, whatever) themselves. They have a point so we are unlikely to talk them out of it.
Is there anything sort of like CVS that a) supports version control and b) manages the transfer of files from dev to test to prod? We'd want something with some controls and logging abilities so that only admins could move things from test to prod, but developers could move things from dev to test. And of course, we'd want the ability to look at logs to see who did what and when.
Is there anything like that out there in the free/open software world?