Home > SQL Databases > Import Azure SQL Database export file to On-Premises SQL Server

Import Azure SQL Database export file to On-Premises SQL Server

Login to On-Premises SQL Server Instance.

 

image

 

Right Click the Databases Folder and select [Import Data-tier Application]

image

 

image

Choose Import from Windows Azure Storage

image

image

Provide the Storage Account information

image

 

Provide the temporary storage location for file to be downloaded.Provide the location which has enough space (.bacpac filesize + 10%)

Specify the target Database Name and file locations

 

image

 

image

 

image

image

image

image

Categories: SQL Databases
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: