gistfile1.sh

scp /some/path/client_dbs/com_shotgunstudio_someclient-pgsql-20121027-173252-v4.1.4-r37048.sql.gz [email protected]:/home/shotgun/
ssh [email protected]
cd shotgun_deploy
vi settings/vm_shotgun_client_test.rb

# edit the :repository line to match the version of code you want to deploy with this db.
# Usually it will match the current version of the db file, so in this case:
# set :repository, "https://svn.shotgunsoftware.com/tags/v4.1.4" 
# save the file

export TARGET=settings/vm_shotgun_client_test.rb
cap sg_db_replace -s db_backup_file_to_load=/home/shotgun/com_shotgunstudio_someclient-pgsql-20121027-173252-v4.1.4-r37048.sql.gz

# lots of output here from Capistrano
# Assuming no errors were generated, you're done.