Using WebDeploy to deploy database updates

Question

We have adopted WebDeploy for a new project and it seems to handle the deployment of our apps to our Dev and Test servers pretty well.

Now we would like to extend the use of WebDeploy to make it deploy database changes too.

Scott Gu's blogpost on webdeploy states:

Web Deploy enables you to not only publish files – but also provision database schema/data, run database change scripts, set security ACLs, and more

... but I can't find any good information on how to run database change scripts with WebDeploy.

Does anyone have guidance, advice, best-practice or informative links for this?

Thanks

Darren.

Kev · Accepted Answer · 2011-05-16 10:31:07Z

8

If you're using Visual Studio 2010 or Visual Studio 2010 Express then you can specify database change scripts in the Package/Publish SQL tab in your project's properties. For more information see the following article:

How to: Deploy a Database With a Web Application Project

answered May 16, 2011 at 10:31

Kev

120k53 gold badges308 silver badges396 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using WebDeploy to deploy database updates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related