Geek Answers Handbook

How to import a bak file into an Azure database

I just created a new SQL database server on the Azure portal . Now my goal is import my local database , which I created .bak file . Could you follow me, how is import there? I searched the web but everywhere I see mention of backpacks files . How to import bak file? Is there any way? I have seen that Azure SQL Database does not currently support this functionality. How to make import database and data the easiest way?

+6
source share
3 answers

Unfortunately, you cannot use the standard .bak file.

You will need to export your database to a .bacpac file. See here

and then import this .bacpac file into azure sql server. see here

Note. Remember to add your IP address to the azure sql server firewall rules.

For more information about transferring your database to Azure, see here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/

+5
source

If you already have a database on your local computer, you can transfer it directly to Azure using SQL Management Studio.

see my answer with a screenshot: fooobar.com/questions/264744 / ...

0
source

  • Use the .bak file to restore the local database on your local device, if the database is not already on your local device, then create the database first and then use the .bak file to restore.

    / li>

  • In Microsoft SQL Management Studio, in the tasks, select Export Database to Azure.

Here he is:)

0
source

More articles:


All Articles