Geek Answers Handbook

Using WebDeploy to Deploy Database Updates

We adopted WebDeploy for a new project and it seems to be very good at deploying our applications on our Dev and test servers.

Now we would like to expand the use of WebDeploy so that it also deploys database changes.

Copy Gu blogpost to webdeploy :

Web Deploy allows you to not only publish files, but also provide database schema / data, start database, modify scripts, set security ACLs and more

... but I cannot find any good information on how to run database modification scripts using WebDeploy.

Does anyone have any recommendations, tips, best practices or informational links?

thanks

Darren.

+8
database deployment database-schema webdeploy
source share
1 answer

If you are using Visual Studio 2010 or Visual Studio 2010 Express, you can specify the scripts for modifying the database on the SQL Package / Publish tab in your project properties. For more information, see the following article:

A practical guide. Database Deployment Using a Web Application Project

+7
source share

More articles:


All Articles