How to restore a database from bak file from azure data studio on Mac
1
Previously on Mac I use mysql operation studio and I click on database and click restore then browse to my bak file, but now they change to azure data studio and when I repeat the same steps I got this error:
"You must enable preview features in order to use restore"
but I cannot figure out hot to enable that. I have googled and tried few things even open my azure, microsoft account on website but I do not see that option.
Can some one help please !
sql
azure-sql-database asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
add a comment |
1
Previously on Mac I use mysql operation studio and I click on database and click restore then browse to my bak file, but now they change to azure data studio and when I repeat the same steps I got this error:
"You must enable preview features in order to use restore"
but I cannot figure out hot to enable that. I have googled and tried few things even open my azure, microsoft account on website but I do not see that option.
Can some one help please !
sql
azure-sql-database asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21
add a comment |
1
1
1
Previously on Mac I use mysql operation studio and I click on database and click restore then browse to my bak file, but now they change to azure data studio and when I repeat the same steps I got this error:
"You must enable preview features in order to use restore"
but I cannot figure out hot to enable that. I have googled and tried few things even open my azure, microsoft account on website but I do not see that option.
Can some one help please !
sql
azure-sql-database asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
Previously on Mac I use mysql operation studio and I click on database and click restore then browse to my bak file, but now they change to azure data studio and when I repeat the same steps I got this error:
"You must enable preview features in order to use restore"
but I cannot figure out hot to enable that. I have googled and tried few things even open my azure, microsoft account on website but I do not see that option.
Can some one help please !
sql
azure-sql-database sql
azure-sql-database asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
edited Nov 28 '18 at 9:20
user1314404
asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
asked Nov 28 '18 at 7:10
user1314404user1314404
3311932
3311932
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21
add a comment |
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21
add a comment |
1 Answer
1
active
oldest
votes
2
- Go to Azure Data Studios > Settings
- Edit settings by clicking on
"new settings editor" - Search for "preview"
- Scroll to the bottom and
check "Enable unreleased preview features"
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
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
});
}
});
draft saved
draft discarded
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%2f53513963%2fhow-to-restore-a-database-from-bak-file-from-azure-data-studio-on-mac%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
2
- Go to Azure Data Studios > Settings
- Edit settings by clicking on
"new settings editor" - Search for "preview"
- Scroll to the bottom and
check "Enable unreleased preview features"
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
add a comment |
2
- Go to Azure Data Studios > Settings
- Edit settings by clicking on
"new settings editor" - Search for "preview"
- Scroll to the bottom and
check "Enable unreleased preview features"
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
add a comment |
2
2
2
- Go to Azure Data Studios > Settings
- Edit settings by clicking on
"new settings editor" - Search for "preview"
- Scroll to the bottom and
check "Enable unreleased preview features"
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
- Go to Azure Data Studios > Settings
- Edit settings by clicking on
"new settings editor" - Search for "preview"
- Scroll to the bottom and
check "Enable unreleased preview features"
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
answered Dec 11 '18 at 15:49
user1705135user1705135
1563
1563
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
add a comment |
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
yes, on Mac I have to click preferencesetting then in search box I search : unreleased preview, then in the line of unreleased preview, I click and move mouse to the pen icon and click and choose "true". Then I can open the restore now, however, when I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open the explorer to browse the file ?
– user1314404
Dec 13 '18 at 8:37
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53513963%2fhow-to-restore-a-database-from-bak-file-from-azure-data-studio-on-mac%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
A .bak file sounds like it's probably SQL Server rather than MySQL. Are you sure you tagged this question correctly?
– ADyson
Nov 28 '18 at 9:08
edited, tks for your comment !
– user1314404
Nov 28 '18 at 9:21