BACPAC files are a specialized set of SQL Scripts that can be restored into Microsoft SQL Server using Management Studio.

To restore a BACPAC database, do the following steps.

1. Open Management Studio and connect to the database server.
   
2. Right-click on Databases and select Import Data-tier Application...
   
3. If the Introduction page appears, check Do not show this page again then click Next
   
4. On the Import Settings page, select Import from local disk then Browse... for the bacpac file and click Next
   
5. Provide the New database name and then click Next
   
6. On the Database Settings
   1. Give your database a name
   2. Click Next
   
7. On the Summary page, click Finish
   
8. The database will be created and the BACPAC will be restored into it
   
9. On the Results page, click Close
   
10. Select Databases and press F5 on your keyboard.
    The database is now visible through Management Studio.