I have used webdeploy 3.0 for deployment, I am changing web.config, sql script file while creating package. Now I want to run changed sql scripts on deployment server, how do i accomplish this?
As we know, Web Deploy enables us to not only publish files – but also provision database schema/data, run database change scripts, set security ACLs, and more.
First this issue about MSDeploy with sql script, I would like to suggest you to refer Scott’s blog about automating deployment with Microsoft Web Deploy, it gives a series of tips about MSdeploy, it will be helpful for you to understand it better,
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
1 Points
10 Posts
How to execute sql scripts after deployment using webdeploy 3.0?
Jun 19, 2013 07:38 AM|sandy41|LINK
I have used webdeploy 3.0 for deployment, I am changing web.config, sql script file while creating package. Now I want to run changed sql scripts on deployment server, how do i accomplish this?
Any suggestions?
VS2010 + webdeploy 3.0 + iis7
Deployment iis webdeploy
All-Star
32817 Points
3815 Posts
Re: How to execute sql scripts after deployment using webdeploy 3.0?
Jun 23, 2013 11:30 PM|Angie xu - MSFT|LINK
Hi,
As we know, Web Deploy enables us to not only publish files – but also provision database schema/data, run database change scripts, set security ACLs, and more.
First this issue about MSDeploy with sql script, I would like to suggest you to refer Scott’s blog about automating deployment with Microsoft Web Deploy, it gives a series of tips about MSdeploy, it will be helpful for you to understand it better,
# Automating Deployment with Microsoft Web Deploy
http://weblogs.asp.net/scottgu/archive/2010/09/13/automating-deployment-with-microsoft-web-deploy.aspx
Regards
Deployment iis webdeploy
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
All-Star
52793 Points
9695 Posts
MVP
Re: How to execute sql scripts after deployment using webdeploy 3.0?
Jun 24, 2013 08:44 AM|Ruchira|LINK
Hello,
Check the below MSDN article
http://msdn.microsoft.com/en-us/library/dd465343(v=vs.100).aspx
Deployment webdeploy
Please 'Mark as Answer' if this post helps you
My Tech Blog