{"id":3394,"date":"2009-10-23T14:09:36","date_gmt":"2009-10-23T14:09:36","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/webdev\/2009\/10\/23\/dev10-beta2-import-from-web-config-file-and-other-changes-for-db-deployment-ui\/"},"modified":"2009-10-23T14:09:36","modified_gmt":"2009-10-23T14:09:36","slug":"dev10-beta2-import-from-web-config-file-and-other-changes-for-db-deployment-ui","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/dotnet\/dev10-beta2-import-from-web-config-file-and-other-changes-for-db-deployment-ui\/","title":{"rendered":"Dev10 Beta2, Import from web.config file and other changes for DB deployment UI"},"content":{"rendered":"

Dev10 Beta2 DB Deployment property page has some changes from Beta1.  Please provide your valuable feedback for us to make it better for you.  Thanks.<\/p>\n

\"image\"<\/a> <\/p>\n

1. Tab page name changed from \u201cDeploy\/SQL\u201d To \u201cDeploy SQL\u201d<\/p>\n

2. Customer can use \u201cImport from Web.config\u201d button to import all the connection strings defined in root web.config to the database entries list.  For example, if web.config contains the following connection strings:<\/p>\n

  <<\/span>connectionStrings<\/span>>\n    <<\/span>add <\/span>name<\/span>=<\/span>"ApplicationServices<\/span>"\n         connectionString<\/span>=<\/span>"data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true<\/span>"\n         providerName<\/span>=<\/span>"System.Data.SqlClient<\/span>" \/>\n    <<\/span>add <\/span>name<\/span>=<\/span>"AdventureWorksConnection<\/span>"\n         connectionString<\/span>=<\/span>"Data Source=1p18-fwg36;Initial Catalog=AdventureWorks;Integrated Security=True<\/span>"\n         providerName<\/span>=<\/span>"System.Data.SqlClient<\/span>" \/>\n  <\/<\/span>connectionStrings<\/span>>\n<\/span><\/pre>\n
<\/a><\/p>\n
Clicking \u201cImport from Web.config\u201d button, you will get two connection names in the database entries list.  Each entry corresponds to a connection string in the web.config, with the connectionString content as the \u201cconnection string for the source database\u201d.  <\/p>\n
\"image\"<\/a> <\/p>\n
 <\/p>\n
3. Database scripting options is changed to a combo box with 3 choices: \u201cSchema Only\u201d, \u201cSchema And Data\u201d and \u201cData Only\u201d  (Beta2 only has schema only and complete database choices).  \u201cExclude objects with no schema information from the generated script\u201d option is removed form UI.  (This SMO setting is called SchemaQualify<\/a>, default is false, you can set to true for each connection in project file if that is what desired.<\/p>\n
4. As Beta1, we hide complex scripting SMO options in the project file.  If you view the project file of this web application, you will see the following:<\/p>\n
    <<\/span>PublishDatabaseSettings<\/span>>\n      <<\/span>Objects<\/span>>\n        <<\/span>ObjectGroup <\/span>Name<\/span>=<\/span>"ApplicationServices<\/span>" Order<\/span>=<\/span>"1<\/span>" Enabled<\/span>=<\/span>"False<\/span>">\n          <<\/span>Destination <\/span>Path<\/span>=<\/span>"" \/>\n          <<\/span>Object <\/span>Type<\/span>=<\/span>"dbFullSql<\/span>">\n            <<\/span>PreSource <\/span>Path<\/span>=<\/span>"data source=.SQLEXPRESS%3bIntegrated Security=SSPI%3bAttachDBFilename=|DataDirectory|aspnetdb.mdf%3bUser Instance=true<\/span>" ScriptSchema<\/span>=<\/span>"True<\/span>" ScriptData<\/span>=<\/span>"False<\/span>" CopyAllFullTextCatalogs<\/span>=<\/span>"False<\/span>" \/>\n            <<\/span>Source <\/span>Path<\/span>=<\/span>"objDebugAutoScriptsApplicationServices_SchemaOnly.sql<\/span>" \/>\n          <\/<\/span>Object<\/span>>\n        <\/<\/span>ObjectGroup<\/span>>\n        <<\/span>ObjectGroup <\/span>Name<\/span>=<\/span>"AdventureWorksConnection<\/span>" Order<\/span>=<\/span>"2<\/span>" Enabled<\/span>=<\/span>"False<\/span>">\n          <<\/span>Destination <\/span>Path<\/span>=<\/span>"" \/>\n          <<\/span>Object <\/span>Type<\/span>=<\/span>"dbFullSql<\/span>">\n            <<\/span>PreSource <\/span>Path<\/span>=<\/span>"Data Source=1p18-fwg36%3bInitial Catalog=AdventureWorks%3bIntegrated Security=True<\/span>" ScriptSchema<\/span>=<\/span>"True<\/span>" ScriptData<\/span>=<\/span>"False<\/span>" CopyAllFullTextCatalogs<\/span>=<\/span>"False<\/span>" \/>\n            <<\/span>Source <\/span>Path<\/span>=<\/span>"objDebugAutoScriptsAdventureWorksConnection_SchemaOnly.sql<\/span>" \/>\n          <\/<\/span>Object<\/span>>\n        <\/<\/span>ObjectGroup<\/span>>\n      <\/<\/span>Objects<\/span>>\n    <\/<\/span>PublishDatabaseSettings<\/span>>\n<\/span><\/pre>\n
    We have CopyAllFullTextCatalogs=\u201dFalse\u201d defined as default to avoid script full text catalog creation SQL script into the script file.  If  it is specified as true or not defined, SQL database with full text catalog will generate a statement which is not transact-able during deploy: <\/p>\n
\n
CREATE FULLTEXT CATALOG [test1234]\n    
WITH ACCENT_SENSITIVITY = ON<\/p>\n
AUTHORIZATION [dbo]<\/p>\n<\/blockquote>\n
5. Some SQL files are meant to be deployed without transaction, such as statement with \u201cCreate Database\u201d, \u201cCreate FULLTEXT CATALOG\u201d etc.  In this case, we need to make sure msdeploy package them with setting Transacted=\u201dFalse\u201d<\/strong><\/em> in their Source <\/em><\/strong>XML tag in the project file.  Such as following:<\/p>\n
        <<\/span>ObjectGroup <\/span>Name<\/span>=<\/span>"NewConnection1<\/span>" Order<\/span>=<\/span>"3<\/span>" xmlns<\/span>=<\/span>"">\n          <<\/span>Destination <\/span>Path<\/span>=<\/span>"" \/>\n          <<\/span>Object <\/span>Type<\/span>=<\/span>"dbFullSql<\/span>">\n            <<\/span>PreSource <\/span>Path<\/span>=<\/span>"Data Source=1p18-fwg35%3bInitial Catalog=test1%3bIntegrated Security=True<\/span>" ScriptSchema<\/span>=<\/span>"True<\/span>" ScriptData<\/span>=<\/span>"False<\/span>" CopyAllFullTextCatalogs<\/span>=<\/span>"True<\/span>" \/>\n            <<\/span>Source <\/span>Path<\/span>=<\/span>"objDebugAutoScriptsNewConnection1_SchemaOnly.sql<\/span>" Transacted<\/span>=<\/span>"False<\/span>" \/>\n          <\/<\/span>Object<\/span>>\n        <\/<\/span>ObjectGroup<\/span>>\n<\/span><\/pre>\n
Note, Source <\/em><\/strong>tag is used for this SMO option, not Presource<\/em><\/strong> tag, since this SMO option will be used in the source manifest file during packaging the generated script to the package file time.  Our process is first use Presource <\/em><\/strong>SMO options to script a database to a temporary SQL file, then use Source<\/em><\/strong>  SMO options in a manifest file to package the temporary SQL file to the web application package.  Similar SMO options include \u201cdropDestinationDatabase\u201d.   <\/p>\n<\/p>\n
Thanks<\/p>\n
Xinyang Qiu \n  
SDETII <\/p>\n
Visual Studio Web Tools<\/p>\n","protected":false},"excerpt":{"rendered":"
Dev10 Beta2 DB Deployment property page has some changes from Beta1.  Please provide your valuable feedback for us to make it better for you.  Thanks. 1. Tab page name changed from \u201cDeploy\/SQL\u201d To \u201cDeploy SQL\u201d 2. Customer can use \u201cImport from Web.config\u201d button to import all the connection strings defined in root web.config to the […]<\/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,7336,7323],"class_list":["post-3394","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aspnet","tag-database","tag-msdeploy","tag-visual-studio-2010"],"acf":[],"blog_post_summary":"
Dev10 Beta2 DB Deployment property page has some changes from Beta1.  Please provide your valuable feedback for us to make it better for you.  Thanks. 1. Tab page name changed from \u201cDeploy\/SQL\u201d To \u201cDeploy SQL\u201d 2. Customer can use \u201cImport from Web.config\u201d button to import all the connection strings defined in root web.config to the […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/3394","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=3394"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/3394\/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=3394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/categories?post=3394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/tags?post=3394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/a><\/a><\/p>\n