Microsoft SQL 2016 server
How create a new database from a BACPAK file in SSMS?
Start SSMS and connect to the target SQL server.
On the database select “Import Data-Tier Application”
Select the BACPAC file to import and click Next
Enter the name of the new database and click Next
Wait during the import.
When Operation Complete click Close.
You have your new database in the new server, including data.
A DAC is a logical database management entity that defines all of the SQL Server objects which associates with a user’s database. A BACPAC includes the database schema as well as the data stored in the database.