Tuesday, May 5, 2009

Compressing Files Independently in Script

Have an interesting issue today.

We have moved away from a 3rd party backup tool to SQL 2005 native. We have hundreds if not little over thousand DB files that now need to be compressed so we can save time on copying them to DEV.

This has nothing to do with Backup procedures or security. Simply put we dont want the dev department killing the bandwidth and time waiting for DBs to copy over to their environment. We want to automate this as much as possible.

I have been looking at the WinZIP CLI. I need to write a script that will take every individual BAK file and place them into their own zip file (or any compression format, personally I dont care). Its the seperation of every file that I am trying to work around. I am not the greatest Windows Script writer in the world. I try to avoid it of I can. However I need to do this. Possible a VB script can pull each file independently, compress it and them move onto the next. I might use an app that will do the copy and compress at the same time. Trying to do this on the cheap if I can.

Lets see what I come up with.

-Boston Tech Guy

No comments:

Post a Comment