search

johanclasson / vso-agent-tasks

Build and Release Tasks for Visual Studio Online and Team Foundation Server
MIT License
20 stars 16 forks source link

DbUp Migration cannot find Scripts folder #47

Closed Kosntantin closed 5 years ago

Kosntantin commented 5 years ago

I have a pipeline on VSTS that automatically deploys my project. I would like to add DBUp to be ran as part of the deployement. I added a DbUp Migration task to the pipeline, but when it runs it says it cannot find my Scripts folder. The script folder is inside my project. Any ideas how i can fix it?

image

johanclasson commented 5 years ago

Are the folder where your SQL-scripts are called Scripts, or have you named your linked artifact alias Scripts?

Just to rule out the obvious. Are you sure that your SQL-scripts are available for the build agent at that path?

My best guess is that you have entered a relative path such as ./Scripts as the Script Folder Path for the DbUp-task. Try using the [...]-button to get a absolute path instead.

Kosntantin commented 5 years ago

image This is my path. THe scripts are in the project in that folder and marked as embedded resources. Is it wrong?

johanclasson commented 5 years ago

Yes. Embedded resources are compiled intro your assembly. My DbUp extension only deals with regular SQL-files.

Have you tried the [...]-button?

Kosntantin commented 5 years ago

image This is what I see when I click it. How I can I make the folder available in there?

johanclasson commented 5 years ago

Here is a link to get your started. https://docs.microsoft.com/en-us/azure/devops/pipelines/build/artifacts?view=vsts

Du you not have anyone at your office you can help you get started with Azure DevOps pipelines?