I would like to sync my development database with actual data from the production databases on a regular basis (say, weekly). I already have the scripts to do this, and the amount of data is not huge.
The problem is that we access the client network through a VPN, so at the moment I have to manually connect (using the cisco vpn client), run the sync, and then disconnect.
Is there anyway to have this done through a script, so that I can set the whole thing up on a schedule and forget about it?