How to deploy a Data-tier application with a reference to master
In VS2017 I have a database project with 4 external database references, of which 2 to SQL Server System Databases. The dacpac-files for the system databases come from C:Program Files (x86)Microsoft Visual Studio2017ProfessionalCommon7IDEExtensionsMicrosoftSQLDBExtensionsSqlServer140SQLSchemas. In Visual Studio the project builds and deploys fine (the latter because it uses a script, and not the dacpac directly).
When I publish the main project's dacpac file using sqlpackage, it does complain that it cannot load master.dacpac. All dacpacs are in the same directory, and do not have references to other databases outside the scope. Also the directory is clean so unpacking would not overwrite a thing. When I try to unpack that file myself, it says: "Could not unpack the package".
These errors do not appear when I either:
- use the master.dacpac from version 90 (all next versions do show the same behavior)
- or generate a master.dacpac from the 2017 master-db myself
However both those methods do not give me the right contents for the dacpac. Specifically I am referencing sys.dm_exec_describe_first_result_set (available from SQL Server 2012).
I'm kind of stuck now on how to proceed, and would love to hear your suggestions!
sql-server ssdt dacpac sqlpackage asked Nov 21 '18 at 11:08
FreddyFreddy
665
add a comment |
In VS2017 I have a database project with 4 external database references, of which 2 to SQL Server System Databases. The dacpac-files for the system databases come from C:Program Files (x86)Microsoft Visual Studio2017ProfessionalCommon7IDEExtensionsMicrosoftSQLDBExtensionsSqlServer140SQLSchemas. In Visual Studio the project builds and deploys fine (the latter because it uses a script, and not the dacpac directly).
When I publish the main project's dacpac file using sqlpackage, it does complain that it cannot load master.dacpac. All dacpacs are in the same directory, and do not have references to other databases outside the scope. Also the directory is clean so unpacking would not overwrite a thing. When I try to unpack that file myself, it says: "Could not unpack the package".
These errors do not appear when I either:
- use the master.dacpac from version 90 (all next versions do show the same behavior)
- or generate a master.dacpac from the 2017 master-db myself
However both those methods do not give me the right contents for the dacpac. Specifically I am referencing sys.dm_exec_describe_first_result_set (available from SQL Server 2012).
I'm kind of stuck now on how to proceed, and would love to hear your suggestions!
sql-server ssdt dacpac sqlpackage asked Nov 21 '18 at 11:08
FreddyFreddy
665
add a comment |
In VS2017 I have a database project with 4 external database references, of which 2 to SQL Server System Databases. The dacpac-files for the system databases come from C:Program Files (x86)Microsoft Visual Studio2017ProfessionalCommon7IDEExtensionsMicrosoftSQLDBExtensionsSqlServer140SQLSchemas. In Visual Studio the project builds and deploys fine (the latter because it uses a script, and not the dacpac directly).
When I publish the main project's dacpac file using sqlpackage, it does complain that it cannot load master.dacpac. All dacpacs are in the same directory, and do not have references to other databases outside the scope. Also the directory is clean so unpacking would not overwrite a thing. When I try to unpack that file myself, it says: "Could not unpack the package".
These errors do not appear when I either:
- use the master.dacpac from version 90 (all next versions do show the same behavior)
- or generate a master.dacpac from the 2017 master-db myself
However both those methods do not give me the right contents for the dacpac. Specifically I am referencing sys.dm_exec_describe_first_result_set (available from SQL Server 2012).
I'm kind of stuck now on how to proceed, and would love to hear your suggestions!
sql-server ssdt dacpac sqlpackage asked Nov 21 '18 at 11:08
FreddyFreddy
665
In VS2017 I have a database project with 4 external database references, of which 2 to SQL Server System Databases. The dacpac-files for the system databases come from C:Program Files (x86)Microsoft Visual Studio2017ProfessionalCommon7IDEExtensionsMicrosoftSQLDBExtensionsSqlServer140SQLSchemas. In Visual Studio the project builds and deploys fine (the latter because it uses a script, and not the dacpac directly).
When I publish the main project's dacpac file using sqlpackage, it does complain that it cannot load master.dacpac. All dacpacs are in the same directory, and do not have references to other databases outside the scope. Also the directory is clean so unpacking would not overwrite a thing. When I try to unpack that file myself, it says: "Could not unpack the package".
These errors do not appear when I either:
- use the master.dacpac from version 90 (all next versions do show the same behavior)
- or generate a master.dacpac from the 2017 master-db myself
However both those methods do not give me the right contents for the dacpac. Specifically I am referencing sys.dm_exec_describe_first_result_set (available from SQL Server 2012).
I'm kind of stuck now on how to proceed, and would love to hear your suggestions!
sql-server ssdt dacpac sqlpackage sql-server ssdt dacpac sqlpackage asked Nov 21 '18 at 11:08
FreddyFreddy
665
asked Nov 21 '18 at 11:08
FreddyFreddy
665
asked Nov 21 '18 at 11:08
FreddyFreddy
665
asked Nov 21 '18 at 11:08
FreddyFreddy
665
asked Nov 21 '18 at 11:08
FreddyFreddy
665
665
add a comment |
add a comment |
0
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',
autoActivateHeartbeat: false,
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%2f53410808%2fhow-to-deploy-a-data-tier-application-with-a-reference-to-master%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
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.
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%2f53410808%2fhow-to-deploy-a-data-tier-application-with-a-reference-to-master%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
