Working yaml file for Azure Dev Ops SQL Test task (using Redgate Build Add-on)
ullull
Posts: 9 New member
I am especially curious about what to specify for sqlproj. It seems whatever I put here gives me this when I get to the test step: ##[error]The specified value for the InputObject parameter is neither a valid database connection string nor a path to an existing NuGet package file or scripts folder: ...
Build task works fine. Here's the YAML I'm using:
steps:
- task: RedgateSqlChangeAutomationBuild@4
inputs:
operation: 'Build SQL Change Automation Project'
sqlProj: '_Database/CSI_SSIS_Migrations/CSI_SSIS_Migrations.sqlproj'
packageName: 'DWBI'
tempServerTypeBuild: 'sqlServer'
tempServerNameBuild: '(localdb)\MSSQLLocalDB'
tempDatabaseNameBuild: 'CSI_SSIS'
authMethodBuild: 'windowsAuth'
useSqlDoc: true
nugetPackageVersionSelector: 'Specific'
nugetPackageVersion: '1.0'
nugetPackageVersionUseBuildId: false
requiredVersionOfDlma: 'latest'
Build task works fine. Here's the YAML I'm using:
steps:
- task: RedgateSqlChangeAutomationBuild@4
inputs:
operation: 'Build SQL Change Automation Project'
sqlProj: '_Database/CSI_SSIS_Migrations/CSI_SSIS_Migrations.sqlproj'
packageName: 'DWBI'
tempServerTypeBuild: 'sqlServer'
tempServerNameBuild: '(localdb)\MSSQLLocalDB'
tempDatabaseNameBuild: 'CSI_SSIS'
authMethodBuild: 'windowsAuth'
useSqlDoc: true
nugetPackageVersionSelector: 'Specific'
nugetPackageVersion: '1.0'
nugetPackageVersionUseBuildId: false
requiredVersionOfDlma: 'latest'
- task: RedgateSqlChangeAutomationBuild@4
inputs:
operation: 'Test SQL Change Automation Project'
sqlProj: 'DWBI.1.0.nupkg'
tempServerType: 'sqlServer'
tempServerName: '(localdb)\MSSQLLocalDB'
tempDatabaseName: 'CSI_SSIS'
authMethod: 'windowsAuth'
testAdvanced: true
requiredVersionOfDlma: 'latest'
inputs:
operation: 'Test SQL Change Automation Project'
sqlProj: 'DWBI.1.0.nupkg'
tempServerType: 'sqlServer'
tempServerName: '(localdb)\MSSQLLocalDB'
tempDatabaseName: 'CSI_SSIS'
authMethod: 'windowsAuth'
testAdvanced: true
requiredVersionOfDlma: 'latest'
Answers
Ok – progress! This gets the tests running:
- task: RedgateSqlChangeAutomationBuild@4
inputs:
operation: 'Test SQL Change Automation Project'
sqlProj: '_Database\CSI_SSIS'
tempServerType: 'sqlServer'
tempServerName: '(localdb)\MSSQLLocalDB'
tempDatabaseName: 'CSI_SSIS'
authMethod: 'windowsAuth'
testAdvanced: true
requiredVersionOfDlma: 'latest'
Relevant log output: