MSBuild and multiple post deploy sql script
up vote
0
down vote
favorite
All,
We implemented CI/CD via DevOps on Azure against our on-prem SQLServers. Most of the changes are DDL changes to Tables, View, SP and Functions.
We would like to implement data zaps (DML) which we are currently accomplishing using sql script files. We tried to implement the same via the Post-Deploy script file but though this technique works it has an inherent limitation of just one post deploy script. Even though we can list multiple sql files at design time at build time it takes the content of each of these files and appends them one below the other.
The problem starts when one of the script errors out. Even though it does give the complete message it does not mention which script file the error originated from. This becomes an issue when we have multiple DML script files with each of them having hundreds of lines of code.
Is there a setting in sqlproj file or some option in MSBuild that would help us specify better config option for these DML scripts and their execution?
I’m looking for a way to make the deploy utility – sqlpackage.exe list the sql file the error originated from apart from the line number and the actual error message.
Thanks,
rgn
sql-server msbuild 
azure-devops dml sqlpackage asked Nov 11 at 0:04
Gopinath Rajee
255
add a comment |
up vote
0
down vote
favorite
All,
We implemented CI/CD via DevOps on Azure against our on-prem SQLServers. Most of the changes are DDL changes to Tables, View, SP and Functions.
We would like to implement data zaps (DML) which we are currently accomplishing using sql script files. We tried to implement the same via the Post-Deploy script file but though this technique works it has an inherent limitation of just one post deploy script. Even though we can list multiple sql files at design time at build time it takes the content of each of these files and appends them one below the other.
The problem starts when one of the script errors out. Even though it does give the complete message it does not mention which script file the error originated from. This becomes an issue when we have multiple DML script files with each of them having hundreds of lines of code.
Is there a setting in sqlproj file or some option in MSBuild that would help us specify better config option for these DML scripts and their execution?
I’m looking for a way to make the deploy utility – sqlpackage.exe list the sql file the error originated from apart from the line number and the actual error message.
Thanks,
rgn
sql-server msbuild azure-devops dml sqlpackage asked Nov 11 at 0:04
Gopinath Rajee
255
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
All,
We implemented CI/CD via DevOps on Azure against our on-prem SQLServers. Most of the changes are DDL changes to Tables, View, SP and Functions.
We would like to implement data zaps (DML) which we are currently accomplishing using sql script files. We tried to implement the same via the Post-Deploy script file but though this technique works it has an inherent limitation of just one post deploy script. Even though we can list multiple sql files at design time at build time it takes the content of each of these files and appends them one below the other.
The problem starts when one of the script errors out. Even though it does give the complete message it does not mention which script file the error originated from. This becomes an issue when we have multiple DML script files with each of them having hundreds of lines of code.
Is there a setting in sqlproj file or some option in MSBuild that would help us specify better config option for these DML scripts and their execution?
I’m looking for a way to make the deploy utility – sqlpackage.exe list the sql file the error originated from apart from the line number and the actual error message.
Thanks,
rgn
sql-server msbuild azure-devops dml sqlpackage asked Nov 11 at 0:04
Gopinath Rajee
255
All,
We implemented CI/CD via DevOps on Azure against our on-prem SQLServers. Most of the changes are DDL changes to Tables, View, SP and Functions.
We would like to implement data zaps (DML) which we are currently accomplishing using sql script files. We tried to implement the same via the Post-Deploy script file but though this technique works it has an inherent limitation of just one post deploy script. Even though we can list multiple sql files at design time at build time it takes the content of each of these files and appends them one below the other.
The problem starts when one of the script errors out. Even though it does give the complete message it does not mention which script file the error originated from. This becomes an issue when we have multiple DML script files with each of them having hundreds of lines of code.
Is there a setting in sqlproj file or some option in MSBuild that would help us specify better config option for these DML scripts and their execution?
I’m looking for a way to make the deploy utility – sqlpackage.exe list the sql file the error originated from apart from the line number and the actual error message.
Thanks,
rgn
sql-server msbuild azure-devops dml sqlpackage sql-server msbuild azure-devops dml sqlpackage asked Nov 11 at 0:04
Gopinath Rajee
255
asked Nov 11 at 0:04
Gopinath Rajee
255
asked Nov 11 at 0:04
Gopinath Rajee
255
asked Nov 11 at 0:04
Gopinath Rajee
255
asked Nov 11 at 0:04
Gopinath Rajee
255
255
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53244636%2fmsbuild-and-multiple-post-deploy-sql-script%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
