D365FO: LCS Exported Bacpac File Contains Corrupted Data
If you experience the below error message when trying to import bacpac file into tier 1 (DEV)ย environment then use the suggested steps to get over this error and get your database imported. Importing to database ‘AxDB_Daxture’ on server ‘.’. SqlPackage.exe : *** Error importing database:Could not load package from ‘C:UsersAdminb1c06345afDownloadsdaxturebackup.bacpac’. At line:13 char:5 +ย ย ย & $LatestSqlPackage $commandParameters “/p:CommandTimeout=0” +ย ย ย ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ย ย + CategoryInfoย ย ย ย ย : NotSpecified: (*** Error impor…backup.bacpac’.:String) [], RemoteException ย ย + FullyQualifiedErrorId : NativeCommandError ย ย File contains corrupted data. ย Based on this docs linkย https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/import-database, download the .NET CORE version of SqlPackage.exe. ย This is the .zip file that can be extracted toย C:TempSqlpackage-dotnetcore From there, instead of using theย Sqlpackage.exe under C:Program Files (x86), use the Sqlpackage.exe in C:TempSqlpackage-dotnetcore. Command will be: C:TempSqlpackage-dotnetcore>SqlPacage.exe /a:import /sf:D:Exportedbacpacmy.bacpac /tsn:localhost /tdn:<target database name> /p:CommandTimeout=1200 ย ย