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

Question

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?

Answer 1

You can have MSDeploy execute a batch file that backs up the IIS directory (see example)

You can also write some SQL, put it in a .sql file, execute the SQL script in the batch file as well. See this example to at least get a start. It is for SQL server, but if you are not using that then hopefully the database you are using has something similar.