dbForgeSync@1 task issues
I am running an azure pipeline deployment where I take my Schema and Static data in Git, packing it using the dbForgePackage task and deploying it against a database using the dbForgeSync tool. My task looks like the following:
- task: dbForgePackage@1
inputs:
id: '${{ parameters.DatabaseNugetPackageID }}.$(versionNumberWithRunID)'
includeDocumentation: false
sourceType: 'subroot'
includeStaticData: true
sourceScriptFolder: ${{ parameters.SourceScriptFolder }}
# Does the actual syncing
- task: dbForgeSync@1
inputs:
sourceType: 'localNuGet'
sourceLocalNugetPath: '${{ parameters.DatabaseNugetPackageID }}.$(versionNumberWithRunID).nupkg'
targetDbName: "XXXXXXX"
targetAuthMethod: 'windowsAuth'
Two problems:
1) When I run this It will sync fine to an empty database the Schema. But the static data is not included. I looked inside the .nuget package to verify it has the static data. I do not see any attributes I might be missing to deploy the static code.
2) When I rerun the pipeline with no changes made to the schema it fails. Nothing changes on the Database side. No connections are open to the database other than the one in the pipeline. Will fail with the following message
##[error]Cannot synchronize a database using a package...
Any help would be helpful in resolving this issue!