Import/Restore BACPAC file in SQL

Requirement

How to Import/Restore BACPAC file


High level resolution steps

Go to SQL database, Right click Import tier application then import file and finish


Detailed resolution steps

Step 1

Open SQL Server management studio, connect to SQL instances where you want to restore database and right click on Database. Then you will get option as shown in below picture. Click on Import Data-tier Application.


Step 2

You will get below window. Click on Next as illustrated in below picture.


tep 3

Then, you will get option to import backpack file either from Local disk or from Windows Azure. As I am explaining the steps to import backpack file from local storage file, we will select Import from Local disk option and browse the file in this step.

Import the file from local Disk and click on Next.


Step 4:

Give the name of your Database and click on Next. You can keep default file path for the Data and Log. However, you can change, file path for Data and Log. After click of next detailed summary of your previous selections will be seen then click Finish


Step 5: Once you click on Finish, it starts creating database, based on your BACPAC file. It may take few minutes to create database, tables, stored procedure, Views etc. and import data to the tables. Wait for process to complete.


Step: 6

Once it is completed, you can see what are the tables, store procedures, views so on created on the result windows as well as you will get option Close, click on Close.