Determine which SQL Server version to restore from Bacpac file

alphonse

Hi,
So I already export my BC database to azure storage, and download the bacpac file. How do I know which SQL Server support my bacpac file?

Thanks

txeriff

"bacpac?" do you mean backup?

I'm not sure what are you doing but you can see the SQL database version if you go into database>properties. As you may know you can have Sql server 2017 and the database working in 2014 compatibility mode for example.

markborges

alphonse wrote: »

Hi,
So I already export my BC database to azure storage, and download the bacpac file. How do I know which SQL Server support my bacpac file?

Thanks

I'm not sure that is possible, as I'm not sure that information is actually contained in the BACPAC... Have you tried extracting it to see the XML data in it?

See more info here:
https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver16#file-format

markborges

txeriff wrote: »

"bacpac?" do you mean backup?

I'm not sure what are you doing but you can see the SQL database version if you go into database>properties. As you may know you can have Sql server 2017 and the database working in 2014 compatibility mode for example.

Here's a reference to what a BACPAC is:

A .bacpac is a related artifact that by default encapsulates the database schema and the data stored in the database. 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.

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