Posted on
LCS Exported bacpac file contains corrupt data

Error:

C:windowssystem32>cd C:Program Files (x86)Microsoft SQL Server140DACbin
C:Program Files (x86)Microsoft SQL Server140DACbin>SqlPackage.exe /a:import /sf:D:Exportedbacpactmctestbackup.bacpac /tsn:localhost /tdn:AxDBCopy4 /p:CommandTimeout=21600

Importing to database ‘AxDBCopy4’ on server ‘localhost’.
*** Error importing database:Could not load package from ‘D:Exportedbacpactmctestbackup.bacpac’.
File contains corrupted data.
C:Program Files (x86)Microsoft SQL Server140DACbin>
***

Solution:

Go to https://docs.microsoft.com/en-us/sql/tools/sqlpackage-download?view=sql-server-ver15 
to download .NET CORE version of Sqlpackage.exe.  This is a .zip file that can be extracted to C:TempSqlpackage-dotnetcore.

From there, instead of using the Sqlpackage.exe under C:Program Files (x86), please can you use the Sqlpackage.exe in C:TempSqlpackage-dotnetcore.

Happy DBing! 
Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh

One Reply to “LCS Exported bacpac file contains corrupt data”

Leave a Reply

Your email address will not be published. Required fields are marked *