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
Β
Β
