Not able to upload the .bacpac file from Azure VM to Azure blob storage container
I am working on a use case, where I will be deploying the DB schema from Development to UAT and Production, but before deploying to UAT and production, i am taking the backup of both UAT and production as a .bacpac file. Below are the steps I have performed in Azure DevOps pipeline
1) Generated the .bacpac file using "Azure SQL Database deployment" inbuilt task. The file generated at "D:\a\r1\a\GeneratedOutputFiles\filename.bacpac
2) check if the file exist on the above path -> Yes file is available.
3) Copy to blob storage using "Azure File Copy" inbuilt task. The Source path which I took is $(System.ArtifactsDirectory)\GeneratedOutputFiles\
and destination is my blob container. PFA, the details about each step and the logs. The issue is I am not able to upload the file to blob storage as the logs says that the source folder is empty, but the file is present in the source folder.
Can someone please take a look and guide me what I am missing here?
@sachin gupta Thank you for posting your question on Microsoft Q&A and for using Azure Services.
My understanding is that you are getting an error while uploading a. BACPAC file from Azure VM to Azure blob storage container.
Are you using sqlpackage or import/export?
@Oury Ba-MSFT Thank you for your response.
I am using SQLPackage export option to generate the .bacpac file and then using the AZ File copy in built task to copy it to blob storage.
I am able to resolve the problem after I change the task version from 4.* to 3.* but I do not understand why the same functionality is not working using task version 4.* Can you please provide some insight on this?
Sign in to comment