patternsqlMinor
Migrating or exporting a database from azure to SQL Server 2016
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?
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.