Mixing
![Starting a multi core CPU as single core [closed]](https://lh3.googleusercontent.com/-yspgfz81fFw/AAAAAAAAAAI/AAAAAAAAD5o/7CFgAMaSHSE/s72-c/photo.jpg?sz=32)
What is Azure SQL Database current version and which SSMS shall I use to backup database?
I have to backup Azure SQL database using Export Data Tier feature. I am getting error - Database source is not a supported version of SQL Server xxx: . (Microsoft.SqlServer.Dac). I am using SSMS version 12.0.2000.8 on local. I need to know Azure SQL Database version and which SSMS version shall I use to backup Azure SQL database but before that I need to know SSMS and Azure SQL Database compatibility. I don't find any clear doc about SSMS and Azure SQL Database compatibility.
azure-sql-database ssms database-backups asked Jan 1 at 6:30
SSDSSD
318
add a comment |
I have to backup Azure SQL database using Export Data Tier feature. I am getting error - Database source is not a supported version of SQL Server xxx: . (Microsoft.SqlServer.Dac). I am using SSMS version 12.0.2000.8 on local. I need to know Azure SQL Database version and which SSMS version shall I use to backup Azure SQL database but before that I need to know SSMS and Azure SQL Database compatibility. I don't find any clear doc about SSMS and Azure SQL Database compatibility.
azure-sql-database ssms database-backups asked Jan 1 at 6:30
SSDSSD
318
add a comment |
I have to backup Azure SQL database using Export Data Tier feature. I am getting error - Database source is not a supported version of SQL Server xxx: . (Microsoft.SqlServer.Dac). I am using SSMS version 12.0.2000.8 on local. I need to know Azure SQL Database version and which SSMS version shall I use to backup Azure SQL database but before that I need to know SSMS and Azure SQL Database compatibility. I don't find any clear doc about SSMS and Azure SQL Database compatibility.
azure-sql-database ssms database-backups asked Jan 1 at 6:30
SSDSSD
318
I have to backup Azure SQL database using Export Data Tier feature. I am getting error - Database source is not a supported version of SQL Server xxx: . (Microsoft.SqlServer.Dac). I am using SSMS version 12.0.2000.8 on local. I need to know Azure SQL Database version and which SSMS version shall I use to backup Azure SQL database but before that I need to know SSMS and Azure SQL Database compatibility. I don't find any clear doc about SSMS and Azure SQL Database compatibility.
azure-sql-database ssms database-backups azure-sql-database ssms database-backups asked Jan 1 at 6:30
SSDSSD
318
asked Jan 1 at 6:30
SSDSSD
318
asked Jan 1 at 6:30
SSDSSD
318
asked Jan 1 at 6:30
SSDSSD
318
asked Jan 1 at 6:30
SSDSSD
318
318
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The current version of Azure SQL Database is "V12".
And the current General Availability (GA) version of SSMS is: SSMS 17.9.1.
I also didn't find any clear doc about SSMS and Azure SQL Database compatibility. But according the link which Azure SQL Database provides for us, we can infer that Microsoft recommends we use the SSMS 17.9.1 or the latest SSMS Preview.
You can update you SSMS to the latest version and try Export Data Tier feature again.
You can download the latest SSMS version here.
Here's an another blob maybe is useful for you: How to upgrade from V11 to V12 SQL Azure.
Hope this can helps you.
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
add a comment |
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%2f53993474%2fwhat-is-azure-sql-database-current-version-and-which-ssms-shall-i-use-to-backup%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The current version of Azure SQL Database is "V12".
And the current General Availability (GA) version of SSMS is: SSMS 17.9.1.
I also didn't find any clear doc about SSMS and Azure SQL Database compatibility. But according the link which Azure SQL Database provides for us, we can infer that Microsoft recommends we use the SSMS 17.9.1 or the latest SSMS Preview.
You can update you SSMS to the latest version and try Export Data Tier feature again.
You can download the latest SSMS version here.
Here's an another blob maybe is useful for you: How to upgrade from V11 to V12 SQL Azure.
Hope this can helps you.
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
add a comment |
The current version of Azure SQL Database is "V12".
And the current General Availability (GA) version of SSMS is: SSMS 17.9.1.
I also didn't find any clear doc about SSMS and Azure SQL Database compatibility. But according the link which Azure SQL Database provides for us, we can infer that Microsoft recommends we use the SSMS 17.9.1 or the latest SSMS Preview.
You can update you SSMS to the latest version and try Export Data Tier feature again.
You can download the latest SSMS version here.
Here's an another blob maybe is useful for you: How to upgrade from V11 to V12 SQL Azure.
Hope this can helps you.
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
add a comment |
The current version of Azure SQL Database is "V12".
And the current General Availability (GA) version of SSMS is: SSMS 17.9.1.
I also didn't find any clear doc about SSMS and Azure SQL Database compatibility. But according the link which Azure SQL Database provides for us, we can infer that Microsoft recommends we use the SSMS 17.9.1 or the latest SSMS Preview.
You can update you SSMS to the latest version and try Export Data Tier feature again.
You can download the latest SSMS version here.
Here's an another blob maybe is useful for you: How to upgrade from V11 to V12 SQL Azure.
Hope this can helps you.
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
The current version of Azure SQL Database is "V12".
And the current General Availability (GA) version of SSMS is: SSMS 17.9.1.
I also didn't find any clear doc about SSMS and Azure SQL Database compatibility. But according the link which Azure SQL Database provides for us, we can infer that Microsoft recommends we use the SSMS 17.9.1 or the latest SSMS Preview.
You can update you SSMS to the latest version and try Export Data Tier feature again.
You can download the latest SSMS version here.
Here's an another blob maybe is useful for you: How to upgrade from V11 to V12 SQL Azure.
Hope this can helps you.
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
answered Jan 1 at 8:34
Leon YueLeon Yue
4873
4873
add a comment |
add a comment |
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%2f53993474%2fwhat-is-azure-sql-database-current-version-and-which-ssms-shall-i-use-to-backup%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
