When you need to import a sql database file (.bak) from an archive in a local folder or from a file share ,  yous tin 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 exist used equally 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 volition go through the to a higher place steps in detail below.

Create a BACPAC file:

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

img_3

Click Adjacent

img_4

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

img_5

Click finishimg_6

Export Database functioning volition exist started

img_7

Y'all will see below screen on successful completion of exporting the database into a bacpac filebacpac_success

File will be as beneath.

bacpac_file

Import .BACPAC file into Azure

img_1.1 1.2 1.3

1.4

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