question

MortazaSahar-2444 avatar image
MortazaSahar-2444 asked ·

Unable to read back up database file (has weird characters) and unable to import this file into azure data studio.

I have been struggling with this for a while. The documentation that is available is very confusing an not relevant.

I am using a Mac operating system and have installed the latest version of azure data studio.

When I open the back up file it is not readable. Like shown below.

8982-microsoft-support.png



I want to be able to import it as a new database in azure data studio. I have tried converting it into a .bak file and uploading it in a docker container and then importing the data base, but this has failed.

Thank You

azure-database-mysql
microsoft-support.png (147.2 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Mike-Ubezzi-MSFT avatar image
Mike-Ubezzi-MSFT answered ·

Hi @MortazaSahar-2444,

Azure Data Studio is not intended to replace the database platform server functionality. Azure Data Studio is intended to allow you to connect to the database specific server instance and like SQL Server Management Studio, interact with and manage a database instance. You will need to install the applicable Azure Data Studio extension(s) in addition to Azure Data Studio itself. Please see: Azure Data Studio Extensions

This tutorial will be useful: Quickstart: Use Azure Data Studio to connect and query SQL Server

Regards,
Mike

6 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Mike,

Thank you for the answer.

I have done the Quick Start Tutorial. But that method doesn't work.

What specific extensions would I need to import this database?

Are there any other tutorials that I can use for this?

BTW, this database was exported from a SQL Server Management Studio.


Apologies for the rudimentary questions, I am trying to figure it out.

Thanks

0 Votes 0 · ·

Although the database was exported using T-SQL in an SSMS query, the database did not actually reside in SSMS. The SSMS session was connected to an SQL Server instance.

You are going to need to deploy an Azure SQL Server instance to then restore the database file as a new database. You cannot restore the database file to Azure Data Studio nor read the contents of the .bak file with the desktop client. If the database file was sourced from an on-premise SQL Server instance, you are going to need to export the database as a .bacpac file. You cannot restore a .bak file to Azure directly.

There are couple items here. First, compatibility between on-premise and Azure SQL. And second, the specific steps to complete this task.

As for the specific extension, you will need to install the following extension:
SQL Server Central Management Servers extension (preview)


0 Votes 0 · ·

Thank you again for the reply.

Is there any other way to do this without creating a SQL Server instance? The reason for this unusual request is due to the hight pricing of this feature. This web app is a small side project, and the solutions are quite expensive.

Kind Regards

0 Votes 0 · ·
Show more comments