We have created a bacpac file from Business Central. It has created a bacpac file in Azure Storage Account. The file size is 4GB.
I then tried to import the database in Azure SQL. After nearly 20-30 minutes it failed with the error below:
The package file provided was not able to be opened. Please run SqlPackage locally to ensure that the file is not corrupt and please ensure that it uploaded to Azure Storage completely.
Then I downloaded the bacpac file onto my local computer and tried to restore it onto a new database in my local sql server using 'Import Data Tier Application' option. It failed immediately with the error below:
**Could not load package from 'C:....//ProductionXX_20230817_01.bacpac'. (Microsoft.SqlServer.Dac)
ADDITIONAL INFORMATION: File contains corrupted data. (Microsoft.Data.Tools.Schema.Sql) File contains corrupted data. (WindowsBase)**
We tried to generating another bacpac file from Business Central, but still getting the same errors.
Has anyone successfully imported a Business Central bacpac file into Azure SQL or On-premise sql server?
