Jenkinsfile

node {
    stage('git checkout'){
        git 'file:///C:/Projects/Chinook.JenkinsDemo'
    }
    stage('Build Dacpac from SQLProj'){
        bat "\"${tool name: 'Default', type: 'msbuild'}\"  /p:Configuration=Release"
        stash includes: 'Chinook.JenkinsDemo\\bin\\Release\\Chinook.JenkinsDemo.dacpac', name: 'theDacpac'
    }
    stage('Deploy Dacpac to SQL Server')
    {
        unstash 'theDacpac'
        bat "\"C:\\Program Files (x86)\\Microsoft SQL Server\\130\\DAC\\bin\\sqlpackage.exe\" /Action:Publish /SourceFile:\"Chinook.JenkinsDemo\\bin\\Release\\Chinook.JenkinsDemo.dacpac\" /TargetServerName:(local) /TargetDatabaseName:Chinook"
        
    }
}