Import .BAK file to Azure SQL Database

When you need to import a sql database file (.bak) from an archive in a local folder or from a file share ,  you can import the database schema and data from a BACPAC file. A BACPAC file is a ZIP file with an extension of .BACPAC containing the metadata and data from a SQL Server database. A BACPAC file can be imported to Azure and can be used as a standard SQL database in Cloud. Import using the Azure portal only supports importing a BACPAC file.

Below are the steps to follow:

  1. Create a BACPAC file
  2. Import the .BACPAC file into Azure

Above steps will create your local database into Azure cloud environment. We will go through the above steps in detail below.

Create a BACPAC file:

Right click on the database and select Tasks –> Export Data-tier Application as below.

img_3

Click Next

img_4

Provide a valid path and a desired filename for the .bacpac file.

img_5

Click finishimg_6

Export Database operation will be started

img_7

You will see below screen on successful completion of exporting the database into a bacpac filebacpac_success

File will be as below.

bacpac_file

Import .BACPAC file into Azure

img_1.11.21.3

1.4

 

The database has now been successfully uploaded into Azure from a local storage.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s