az_devop_build_pipe_02.yml

# Starter pipeline
# Start with a minimal pipeline that you can customize to build and deploy your code.
# Add steps that build, run tests, deploy, and more:
# https://aka.ms/yaml

# there are three types of triggers: pull triggers, scheduled triggers 
# and the standard, which is specified with the "trigger" keyword
# specify at least one branch, which triggers, 
# when this branch is pushed 

trigger:
- master

# pool specifies, on which agents the pipeline jobs can run
pool:
#  vmImage: 'windows-latest'
  name: 'Default'

# steps lists all the single steps the agent
# execute
# script executes some code in a dos cli
# task is a description of all tasks, which are installed
# on the left side of this pane
steps:
- script: echo Hello, world!
  displayName: 'Run a one-line script'

- script:
    echo Add other tasks to build, test, and deploy your project.
    echo See https://aka.ms/yaml
  displayName: 'Run a multi-line script'

# This task is the SCA builder and publisher of the 
# nuget package
# tried with a localdb and failed
# This section is for the az vmware agent
#- task: RedgateSqlChangeAutomationBuild@4
#  inputs:
#    operation: 'Build SQL Change Automation Project'
#    sqlProj: 'CONTOSO_DW_SCA_ONE/CONTOSO_DW_SCA_ONE.sqlproj'
#    packageName: 'CONTOSO_DW_SCA_ONE'
#    tempServerTypeBuild: 'localDB'
#    nugetPackageVersionSelector: 'Specific'
#    nugetPackageVersion: '1.0'
#    requiredVersionOfDlma: 'latest'

# trying it with a proper sql server as build server 
# this section is for the local agent on SLS-LT-ALEXD2
- task: RedgateSqlChangeAutomationBuild@4
  inputs:
    operation: 'Build SQL Change Automation Project'
    packageName: 'CONTOSO_DW_SCA_ONE'
    tempServerTypeBuild: 'sqlServer'
    tempServerNameBuild: 'SLS-LT-ALEXD2\SQLEXPRESS'
    tempDatabaseNameBuild: 'CONTOSO_TEMP'
    authMethodBuild: 'windowsAuth'
    nugetPackageVersionSelector: 'Specific'
    nugetPackageVersion: '1.0'
    requiredVersionOfDlma: 'latest'