Have an SVN repository. It has a TRUNK with all the production code and a branch for each release. The release code is then copied to production and merged back to to the TRUNK once validated as working during a deployment. We use a spreadsheet to to communicate the exact version number to have promoted to production.
My idea is to write a script in Perl, Java, or possibly even Visual Basic to read the spreadsheet and deploy the files.
So I'm wondering if there are any APIs or modules out that can connect to SVN and retrieve and copy a specific file (from a specific branch with a specific version number) to a specific final location? This is all in MS Windows. I just have not been able to find anything.
I also know there are better ways to handle SVN than the method being used, but please keep the answers to what I'm asking for vs. suggesting better ways to handle SVN. Thanks!