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

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

Solution

  • 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.