Trying to deploy an SQL DB on Azure pipelines PATH ISSUE

Question

I'm trying to deploy a .NET project which has multiple projects in it as well as an sql database(ssdt) but I'm having a hard time finding out what path to use to get the .dacpac generated.

In dotnet build I have Arguments: --configuration Release

I also want to know if the copy task is properly placed, or should it be below dotnet publish.

Max Morrow · Accepted Answer · 2021-02-16 18:28:08Z

1

You can use a more general wildcard to find your dacpac, unless you're generating more than one, this would work:

*.dacpac

As a troubleshooting tip, if you have trouble finding files generated on your agents, you can add a small bash script to your pipeline to list all files & the primary working directory:

echo "-----------------"
echo "-- Primary Working Directory"
pwd
echo "-- All Directories & Files"
ls -LR

answered Feb 16, 2021 at 18:28

Max Morrow

1,3368 silver badges15 bronze badges

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

2 Comments

Kreetchy Over a year ago

Thanks for the info, and do you perhaps know if I should do the copy task after dotnet publish or before that?

Max Morrow Over a year ago

I typically add my post-build scripts after publish to ensure that all of my build artifacts are complete before changing them. In this scenario, you should be good with it before or after the publish.

Collectives™ on Stack Overflow

Trying to deploy an SQL DB on Azure pipelines PATH ISSUE

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related