HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Migrating or exporting a database from azure to SQL Server 2016

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
exportingsqldatabasemigratingazureserverfrom2016

Problem

I am playing around with SQL Azure and in my learning curve. I Have migrated a database from my on premises instance to the Azure server. Now my question is, how do I move a database from Azure to on premises instance.

Source : Azure , Database name : Azuretest

Destination : Sql server 2016 on premises instance in my laptop.

Is Azure to On Premise database migration possible?

Solution


  • Export the Data-tier to local disk from the Azure database. It will save a bacpac file.





Right click the database you need to export --> Task-->Export
data-tier application and follow the steps until the bacpac file is
created.



  • Import the backpack file from the local disk to the On premises Instance by using the same utility from tasks.





Right click the database branch in your on premise instance --> Import
data tier application and now use the bacpac file saved in first step
to create the database.

Context

StackExchange Database Administrators Q#182398, answer score: 4

Revisions (0)

No revisions yet.