Skip to content

Instantly share code, notes, and snippets.

Created April 4, 2017 23:54
What would you like to do?
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"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment