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
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
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
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
