Thursday, March 25, 2021

what is the primary use case of BACPAC ?

 A BACPAC is a Windows file with a .bacpac extension that encapsulates a database's schema and data. The primary use case for a BACPAC is to move a database from one server to another or to migrate a database from a local server to the cloud - and archiving an existing database in an open format.

A BACPAC on the other hand, is focused on capturing schema and data supporting two main operations:

1) Export : The user can export the schema and the data of a database to a BACPAC.

2) Import: The user can import the schema and the data into a new database in the host server.

https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver15#bacpac




No comments:

Post a Comment