Backup a Table to an SQL File in SSMS Shows how to restore a .bacpac file by right-clicking a database and selecting “Import Data-tier Application.”