{"id":1764,"date":"2013-03-06T14:00:10","date_gmt":"2013-03-06T14:00:10","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/webdev\/2013\/03\/06\/visual-studio-web-deployment-tutorial-series-updated-for-windows-azure-and-localdb\/"},"modified":"2013-03-06T14:00:10","modified_gmt":"2013-03-06T14:00:10","slug":"visual-studio-web-deployment-tutorial-series-updated-for-windows-azure-and-localdb","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/dotnet\/visual-studio-web-deployment-tutorial-series-updated-for-windows-azure-and-localdb\/","title":{"rendered":"Visual Studio Web Deployment Tutorial Series Updated for Windows Azure and LocalDB"},"content":{"rendered":"<p>This week we published an updated version of the popular 12-part tutorial series that shows how to deploy an ASP.NET web application with SQL Server databases. Here are links to the new tutorials, with notes about what&rsquo;s in them and what&rsquo;s new:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/introduction\" target=\"_blank\" rel=\"noopener\">Introduction<\/a>&nbsp;<\/li>\n<ul>\n<li>Overview of the series, prerequisites, download and run the sample application.<\/li>\n<li>New overview of database deployment options. The tutorials show how to use Entity Framework Code First Migrations and the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dd394698.aspx#dbdacfx\" target=\"_blank\" rel=\"noopener\">dbDacFx<\/a> provider (for deploying SQL Server databases without using Migrations).&nbsp; The old ones showed Migrations and the dbFullSQL provider (for migrating SQL Server Compact to SQL Server).<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/preparing-databases\" target=\"_blank\" rel=\"noopener\">Preparing for Database Deployment<\/a>&nbsp;<\/li>\n<ul>\n<li>How to set up Code First Migrations and create data deployment scripts for use with <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dd394698.aspx#dbdacfx\" target=\"_blank\" rel=\"noopener\">dbDacFx<\/a> deployment.<\/li>\n<li>Uses LocalDB instead of SQL Server Compact for the development databases. (For people who are using SQL Server Compact, <a href=\"http:\/\/www.asp.net\/web-forms\/tutorials\/deployment\/deployment-to-a-hosting-provider\/deployment-to-a-hosting-provider-introduction-1-of-12\" target=\"_blank\" rel=\"noopener\">the old tutorial<\/a> has been left on the ASP.NET site.)<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/web-config-transformations\" target=\"_blank\" rel=\"noopener\">Web.config File Transformations<\/a><\/li>\n<ul>\n<li>How to set up build configuration Web.config transformations (e.g., Release and Debug).<\/li>\n<li>Introduces profile-specific Web.config transformations (e.g., Test and Production).<\/li>\n<li>Demonstrates the new Web.config transformation preview feature, which makes testing and debugging transforms much easier.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/project-properties\" target=\"_blank\" rel=\"noopener\">Project Properties<\/a><\/li>\n<ul>\n<li>Review of deployment options specified in project properties.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/deploying-to-iis\" target=\"_blank\" rel=\"noopener\">Deploying to Test (to IIS on the development computer)<\/a><\/li>\n<ul>\n<li>How to install IIS, install SQL Server Express, create SQL Express databases, and deploy the application to local IIS.<\/li>\n<li>Now covers IIS installation for both Windows 8 and Windows 7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/li>\n<li>Deploys schema and data for the membership database by using the dbDacFx provider.<\/li>\n<li>Deploys schema and data for the application database by using Code First Migrations.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/setting-folder-permissions\" target=\"_blank\" rel=\"noopener\">Setting Folder Permissions<\/a><\/li>\n<ul>\n<li>How to enable the application to write log files in an application folder when it runs in local IIS.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/deploying-to-production\" target=\"_blank\" rel=\"noopener\">Deploying to Production<\/a>&nbsp;&nbsp;&nbsp; <\/li>\n<ul>\n<li>How to deploy to staging and production environments in separate Windows Azure Web Sites. (Most of the deployment procedures shown apply also to third-party hosting providers, and differences are noted.) <\/li>\n<li>Creates profile-specific transformation files for staging and production.<\/li>\n<li>Deploys robots.txt file to staging, excludes it from production by editing the .pubxml file.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/deploying-a-code-update\" target=\"_blank\" rel=\"noopener\">Deploying a Code Update<\/a><\/li>\n<ul>\n<li>How to deploy an application update that doesn&rsquo;t involve a database change.<\/li>\n<li>Uses FTP to add and remove app_offline.htm, shows how to get credentials for FTP access from the Windows Azure .publishsettings file.<\/li>\n<li>Previews file changes to be deployed by double-clicking files in the Publish Web Preview pane.<\/li>\n<li>Deploys individual files and previews file changes by right-clicking files in Solution Explorer.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/deploying-a-database-update\" target=\"_blank\" rel=\"noopener\">Deploying a Database Update<\/a><\/li>\n<ul>\n<li>How to deploy a database update, using Migrations for the application database and dbDacFx for the membership database.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/command-line-deployment\" target=\"_blank\" rel=\"noopener\">Command Line Deployment<\/a><\/li>\n<ul>\n<li>New tutorial that shows how to deploy by using the command line.<\/li>\n<li>Reviews and explains key command line options.<\/li>\n<li>Shows how to get credentials for Windows Azure deployment from the .publishsettings file.<\/li>\n<\/ul>\n<li><a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/deploying-extra-files\" target=\"_blank\" rel=\"noopener\">Deploying Extra Files<\/a><\/li>\n<ul>\n<li>New tutorial that shows how to customize the web publish pipeline by editing the .pubxml file, in order to deploy extra files that are not included in the project.<\/li>\n<\/ul>\n<li>&nbsp; <a href=\"http:\/\/www.asp.net\/mvc\/tutorials\/deployment\/visual-studio-web-deployment\/troubleshooting\" target=\"_blank\" rel=\"noopener\">Troubleshooting<\/a><\/li>\n<ul>\n<li>Common errors and how to resolve them.<\/li>\n<\/ul>\n<\/ul>\n<p>Feedback is welcome; you can post comments here or on the tutorials themselves.<\/p>\n<p><b>&#8212; Tom Dykstra <\/b><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week we published an updated version of the popular 12-part tutorial series that shows how to deploy an ASP.NET web application with SQL Server databases. Here are links to the new tutorials, with notes about what&rsquo;s in them and what&rsquo;s new: Introduction&nbsp; Overview of the series, prerequisites, download and run the sample application. New [&hellip;]<\/p>\n","protected":false},"author":424,"featured_media":58792,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[],"class_list":["post-1764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aspnet"],"acf":[],"blog_post_summary":"<p>This week we published an updated version of the popular 12-part tutorial series that shows how to deploy an ASP.NET web application with SQL Server databases. Here are links to the new tutorials, with notes about what&rsquo;s in them and what&rsquo;s new: Introduction&nbsp; Overview of the series, prerequisites, download and run the sample application. New [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/1764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/users\/424"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/comments?post=1764"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/1764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media\/58792"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media?parent=1764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/categories?post=1764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/tags?post=1764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}