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

Leave a Reply

Your email address will not be published. Required fields are marked *