visual-studio-2010msdeployone-click-web-publishing

How to backup existing database and website as part of a MSDeploy package?


I am researching one-click deployment with Visual Studio 2010, the current deployment process involves zipping up the contents of the IIS folder and taking a backup of the current database before completing the remaining manual deployment steps. This allows us to roll back a deployment, I need to retain the essence of this process if not the specifics.

Is there a way of automating this with MSDeploy?


Solution

  • Finally I found the answer, thank you to kniemczak for posting the information about how to backup IIS and SQL Server from the command line.

    It seems the following:

    msdeploy.exe
         -verb:sync -source:runCommand='C:\Scripts\Backup.cmd' 
         -dest:auto,computername=192.168.0.1

    Should cover my needs.