Working yaml file for Azure Dev Ops SQL Test task (using Redgate Build Add-on)

ullullullull 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'
- 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'

Answers

  • ullullullull Posts: 9 New member
    edited July 27, 2020 7:55PM

    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:


Sign In or Register to comment.