CODEWITHSUNDEEP
azureazure-sql-databaseazure-storageazure-virtual-networkazure-pack
Neo
Neo

Reputation: 16219

How to restore sql database in Private Azure Cloud subscription?

I want to restore my database bacpac file into Private Azure Subscription but I do not get any option in Azure portal :(

Is there any way to do this? enter image description here

Upvotes: 0

Views: 168

Answers (2)

pehteh
pehteh

Reputation: 116

The Import/Export service is not available on Private Azure Cloud.

You will need to use SSDT to import into your SQL DB for the Private Azure Cloud Subscription.

Upvotes: 0

sudhansu63
sudhansu63

Reputation: 6180

Option 1 : If you have the Database.bacpac file in Azure blob storage you can Export that to a new Database in the Portal

Choose a Database => Configure =>  NewDatabase (New database from Export)

or

New (Lower left Corner) => DataService => SQL DataBase => Import from Blob

Option2

If you have your Database.bacpac File in local. Download and Install SSSDT (Sql Servert Data Tools)

Connect to your database using SSMS(Sql Server management studio).

then Tasks => Deploy Database to SQL Azure and follow the steps.

Upvotes: 1

Related Questions