Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I blogged about this at <a href="http://sedodream.com/2013/03/06/HowToPublishOneWebProjectFromASolution.aspx" rel="noreferrer">http://sedodream.com/2013/03/06/HowToPublishOneWebProjectFromASolution.aspx</a> a few months back. I've copied the details here as well, see below.</p> <hr> <p>Today on twitter <a href="https://twitter.com/nunofcosta" rel="noreferrer">@nunofcosta</a> asked me roughly the question “How do I publish one web project from a solution that contains many?”</p> <p>The issue that he is running into is that he is building from the command line and passing the following properties to msbuild.exe.</p> <pre><code>/p:DeployOnBuild=true /p:PublishProfile='siteone - Web Deploy' /p:Password=%password% </code></pre> <p>You can read more about how to automate publishing at <a href="http://sedodream.com/2013/01/06/CommandLineWebProjectPublishing.aspx" rel="noreferrer">http://sedodream.com/2013/01/06/CommandLineWebProjectPublishing.aspx</a>.</p> <p>When you pass these properties to msbuild.exe they are known as global properties. These properties are difficult to override and are passed to every project that is built. Because of this if you have a solution with multiple web projects, when each web project is built it is passed in the same set of properties. Because of this when each project is built the publish process for that project will start and it will expect to find a file named <strong>siteone – Web Deploy.pubxml</strong> in the folder *Properties\PublishProfiles*. If the file doesn’t exist the operation may fail.</p> <p><strong>Note: If you are interested in using this technique for an orchestrated publish see my comments at <a href="https://stackoverflow.com/a/14231729/105999">https://stackoverflow.com/a/14231729/105999</a> before doing so.</strong></p> <p>So how can we resolve this?</p> <p>Let’s take a look at a sample (see links below). I have a solution, <strong>PublishOnlyOne</strong>, with the following projects.</p> <ol> <li>ProjA</li> <li>ProjB</li> </ol> <p>ProjA has a publish profile named ‘<strong>siteone – Web Deploy</strong>’, ProjB does not. When trying to publish this you may try the following command line.</p> <pre><code>msbuild.exe PublishOnlyOne.sln /p:DeployOnBuild=true /p:PublishProfile=’siteone – Web Deploy’ /p:Password=%password% </code></pre> <p><em>See publish-sln.cmd in the samples.</em></p> <p>If you do this, when its time for ProjB to build it will fail because there’s no <strong>siteone – Web Deploy</strong> profile for that project. Because of this, we cannot pass DeployOnBuild. Instead here is what we need to do.</p> <ol> <li>Edit ProjA.csproj to define another property which will conditionally set DeployOnBuild</li> <li>From the command line pass in that property</li> </ol> <p>I edited ProjA and added the following property group before the Import statements in the .csproj file.</p> <pre><code>&lt;PropertyGroup&gt; &lt;DeployOnBuild Condition=" '$(DeployProjA)'!='' "&gt;$(DeployProjA)&lt;/DeployOnBuild&gt; &lt;/PropertyGroup&gt; </code></pre> <p>Here you can see that DeployOnBuild is set to whatever value DeployProjA is as long as it’s not empty. Now the revised command is:</p> <pre><code>msbuild.exe PublishOnlyOne.sln /p:DeployProjA=true /p:PublishProfile=’siteone – Web Deploy’ /p:Password=%password% </code></pre> <p>Here instead of passing DeployOnBuild, I pass in DeployProjA which will then set DeployOnBuild. Since DeployOnBuild wasn’t passed to ProjB it will not attempt to publish.</p> <p>You can find the complete sample at <a href="https://github.com/sayedihashimi/sayed-samples/tree/master/PublishOnlyOne" rel="noreferrer">https://github.com/sayedihashimi/sayed-samples/tree/master/PublishOnlyOne</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POPublish one web project from solution with msbuild
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USSayed Ibrahim Hashimi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPublish one web project from solution with msbuild
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONice writeup! This definitely makes sense. However, I ended up solving my problem by creating an msbuild file based on another question on SO: http://stackoverflow.com/questions/3097489/how-to-publish-web-with-msbuild
      singulars
      1. PO
      1. USCaleb Jares
    2. COThis was a very clever answer, and I wanted to thank you very much for it. It solved a serious problem for me!
      singulars
      1. PO
      1. USMatt DiTrolio
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload