Restore AdventureWorks2022.bak Database in Azure Data Studio on mac m1

Tayi, Venkata Surya 0 Reputation points
2024-06-17T09:28:31.7566667+00:00

I had tried restoring the AdventureWorks2022 and 2019 .bak files in Azure data studio on mac m1 chip(sonomo 14.5). The restore button is not able to popup to click. SO it is unable to restore the AdventureWorks. bak files Screenshot 2024-06-17 at 2.23.43 PM

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,746 Reputation points
    2024-06-17T09:42:13.5866667+00:00

    In your screenshot I see you are not connected to SQL Server.

    Further is see you are in folder "Extensions" and I see "Preview"; are you using an add-in for restore? Which version of Azure Data Studio are you using?

    Connect to a SQL Server and try the build-in restore function.


  2. GeethaThatipatri-MSFT 28,932 Reputation points Microsoft Employee
    2024-06-24T23:03:27.7333333+00:00

    @Tayi, Venkata Surya I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

    Issue: You are having trouble restoring the AdventureWorks2022 and 2019 .bak files in Azure Data Studio on a Mac M1 chip. The restore button is not popping up, so you are unable to restore the AdventureWorks.bak files.

    Solution: As you mentioned you resolved the issue. In document its shows that for apple silicon users i need to install some software called Rosetta 2. After installing it you were able to restore.

    User's image

    Please remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution.

    Regards

    Geetha

    0 comments No comments