微软建站SQL Server数据库项目:将部署和发布目标绑定到生成配置

问题描述

Visual Studio2012.SQLServer数据库项目.

Visual Studio 2012. SQL Server Database Project.

在解决方案中创建了四个构建配置:Debug，DevDb，TestDb，LocalDb.

Four build configurations were created in solution: Debug, DevDb, TestDb, LocalDb.

在项目中创建了三个发布配置文件:DevDb.publish.xml，TestDb.publish.xml，LocalDb.publish.xml

Three publish profiles were created in project: DevDb.publish.xml, TestDb.publish.xml, LocalDb.publish.xml

按下F5按钮(！)，我想这样做:

• 部署项目，其中包含来自项目属性如果的连接字符串构建配置为 Debug .
• 发布项目，带有连接字符串从相应的发布配置文件中如果构建配置为 DevDb ， TestDb 或 LocalDb .

• deploy project with connection string from project properties ifbuild configuration is Debug.
• publish project with connection stringfrom the corresponding publish profiles if build configuration isDevDb, TestDb or LocalDb.

为此，我编辑项目(.sqlproj)xml，尝试捕获对Deploy目标的调用，并用自定义行为替换标准的Deploy目标:

To do this I edit project (.sqlproj) xml, trying to catch a call of the Deploy target and replace the standart Deploy target with a custom behavior:

<Target Name="Deploy">

    <!-- The first statment is for Debug configuration  -->

    <MSBuild Condition=" '$(Configuration)' == 'Debug' "
      Targets="Deploy"
      Projects="$(MSBuildProjectFile)"
      Properties="Configuration=$(Configuration);"
    />

    <!-- The second statement is for DevDb, TestDb, LocalDb configurations  -->

    <MSBuild Condition=" '$(Configuration)' != 'Debug' "
      Targets="SqlPublish"
      Projects="$(MSBuildProjectFile)"
      Properties="SqlPublishProfilePath=$(Configuration).publish.xml;
                  Configuration=$(Configuration);"
    />
 </Target>

第二条语句工作正常，我可以将其部署到正确的目的地.

The second statement works fine and I get deployment to the right destination.

问题出在第一条语句上-它产生了循环依赖.

The problem is with the first statement - it produces a circular dependency.

错误MSB4006:目标依赖关系图中涉及目标部署"的循环依赖.

我的问题是:如何相交(捕获并替换)标准目标，以及是否需要再次调用标准目标?

My question is: how to intersect (catch and replace) the standart target and if it's required to invoke the standart target again?

还是我要重新发明轮子，还有另一种方法可以做我想做的事情?(我在上面的按F5按钮"中描述了我想要的内容:)

Or am I trying to reinvent the wheel and there is another way to do what I want?(What I want is described above under words "Pushing F5 button" :)

推荐答案

我认为我有解决方案.

因此，如果将带有Condition和自定义Target的PropertyGroup放在数据库项目xml文件的末尾:

So if we put such a PropertyGroup with Condition and a custom Target to the end of database project xml file:

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">

    ----------- Skip -----------

  <PropertyGroup Condition=" '$(Configuration)' != 'Debug' and Exists('$(Configuration).publish.xml')">
    <DeployDependsOn>
      PublishDatabase
    </DeployDependsOn>
  </PropertyGroup>

  <Target Name="PublishDatabase"> <!-- Custom Target -->
    <Message
        Text="Deploy is replaced with SqlPublish for configuration = $(Configuration)"
        Importance="high" />

    <MSBuild
        Targets="SqlPublish"
        Projects="$(MSBuildProjectFile)"
        Properties="SqlPublishProfilePath=$(Configuration).publish.xml;
                    Configuration=$(Configuration);" />
  </Target>
</Project>

我们将获得以下行为:

• 如果解决方案构建配置与Debug不同，并且存在发布配置文件* .publish.xml，则部署目标和操作将被替换为SqlPublish目标，并且此发布操作将获得所需的配置，例如连接来自相应的发布配置文件的字符串.
• 如果解决方案构建配置为调试"，则当标准Visual Studio从项目属性中获取连接字符串时，我们将保留该行为.

• If the solution build configuration is differ from Debug and the publish profile *.publish.xml exists, then the Deploy target andoperation will be replaced with SqlPublish target and this publishoperation will get the required configuration such as connectionstring from the corresponding publish profile.
• If the solution build configuration is Debug, then we preserve the standart Visual Studio behaviour when it take th connection string from the project properties.

这篇关于微软建站SQL Server数据库项目:将部署和发布目标绑定到生成配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！