Vishal\u2019s post<\/a> for web.config connection string transformation so that packaged web.config file will contain the corresponding deploy time connection string.<\/p>\n6. Save, right click solution explorer project item, choose Package->\u201cCreate package\u201d context menu item. Wait for the process end.<\/p>\n
7. Now, you\u2019ve created a package contains mdf\u2019s file\u2019s sql script, and without the mdf file under app_data directory. For debug configuration, default package location is at <project root>objdebugpackageprojectName.zip.<\/p>\n
8. You can use the generated <project root>objdebugpackageprojectName_deploy.cmd to test deploy the application and database.<\/p>\n
Note:<\/p>\n
1. |DataDirectory| inside connection name can only be used inside VS environment. Msdeploy dbFullSql provider does not recognize |DataDirectory| in its commandline behavior. <\/p>\n
2. In Dev10 Beta1, scripting mdf file has some limitations which may require workaround. For example, in the connection string, if the expanded AttachDBFilename length is longer than 100 characters, the generated scripts may be in wrong order, and if it is longer than 127 characters, it does not generate at all. In such time, please add \u201cInitial Catalog=UniqueShortName\u201d to the connection string as a short database logical name.<\/p>\n
3. If User Instance is not used in the connection string, if mdf file is opened inside VS, it might be locked to prevent packaging. In such case, adding User Instance=\u201dtrue\u201d to the connection string, or close the mdf data connection from VS server explorer can do the trick.<\/p>\n
4. The above procedures and screen shots are based on Dev10 Beta1, which may be changed in future versions.<\/p>\n
Thanks.<\/p>\n
Xinyang Qiu \n
SDETII <\/p>\n
Visual Studio Web Tools<\/p>\n","protected":false},"excerpt":{"rendered":"
For many web applications developed using Visual Studio, developers uses SQL express with mdf database file under app_data folder. If deploying data host requires SQL server, developers have to find ways to deploy the schema and data from mdf file to the host SQL server. Dev10 Beta1 provides an easy solution to publish the mdf […]<\/p>\n","protected":false},"author":404,"featured_media":58792,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[7341,7323,7329],"class_list":["post-3474","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aspnet","tag-database","tag-visual-studio-2010","tag-web-deployment"],"acf":[],"blog_post_summary":"
For many web applications developed using Visual Studio, developers uses SQL express with mdf database file under app_data folder. If deploying data host requires SQL server, developers have to find ways to deploy the schema and data from mdf file to the host SQL server. Dev10 Beta1 provides an easy solution to publish the mdf […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/3474","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\/404"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/comments?post=3474"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/3474\/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=3474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/categories?post=3474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/tags?post=3474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"image\"](\"https:\/\/devblogs.microsoft.com\/dotnet\/wp-content\/uploads\/sites\/10\/2009\/09\/image_thumb.png\" "\\"image\\"")
<\/a> <\/p>\n![\"image\"](\"https:\/\/devblogs.microsoft.com\/dotnet\/wp-content\/uploads\/sites\/10\/2009\/09\/image_thumb_2.png\" "\\"image\\"")
<\/a> <\/p>\n