Using PublishProfile in MSBuild for Database Project

Question

I have a database project in Visual Studio 2012. I am trying to create an MSBuild project to publish the database on the build server. In my solution, I have a Publish Profile that I would like to use on the build server.

I have the following target setup:

<Target Name="BuildDatabases">       
        <MSBuild Projects="$(DBProjectPath)" Targets="Build;Deploy" Properties="DeployOnBuild=true;SqlPublishProfilePath=BuildServer.publish">
        </MSBuild>
    </Target>

I've tried a combination of PublishProfile and SqlPublishProfilePath to no avail. I always receive:

Deploy Error: The connection string is not valid

I can use the Publish Profile inside VS with no connection issues.

B Z · Accepted Answer · 2012-12-04 22:38:07Z

7

Figured it out:

<Target Name="BuildDatabases">
    <MSBuild Projects="$(DBProjectPath)" Targets="Build;Publish" Properties="DeployOnBuild=true;SqlPublishProfilePath=BuildServer.publish.xml">
    </MSBuild>
</Target>

I had to use "Build;Publish" for target, I was using "Build;Deploy"

answered Dec 4, 2012 at 22:38

B Z

9,46217 gold badges71 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using PublishProfile in MSBuild for Database Project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related