CODEWITHSUNDEEP
azure-sql-database
Courageous Heart
Courageous Heart

Reputation: 528

Importing a Azure SQL DB

I am facing a weird issue, can someone please help with this. I have a .bacpac file on the Blob storage, the bacpac file size is around 800 MB. This file was created by doing an export from one of the SQL DB on Azure which is of 4 GB.

While I am trying to import the .bacpac file, only the DB schema is created in the new database, data in the tables is missing. Can someone please suggest with this.

Many thanks

Upvotes: 1

Views: 497

Answers (1)

Pradebban Raja
Pradebban Raja

Reputation: 463

Create a New Database by Importing BACPAC File

Log on to the Azure Management Portal. Click New > Data Services > SQL Database > Import. ... Click the folder under BACPAC URL to navigate to the Storage Account, Container, and file name of the exported .bacpac file. ... Specify a name for the new SQL database.

This works perfectly without any issues.

Upvotes: 1

Related Questions