Tuesday, October 20, 2020

D365FO: π™‡π˜Ύπ™Ž π™šπ™­π™₯π™€π™§π™©π™šπ™™ π™—π™–π™˜π™₯π™–π™˜ π™π™žπ™‘π™š π™˜π™€π™£π™©π™–π™žπ™£π™¨ π™˜π™€π™§π™§π™ͺπ™₯π™©π™šπ™™ 𝙙𝙖𝙩𝙖

If you experience 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:\Users\Adminb1c06345af\Downloads\daxturebackup.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:\Temp\Sqlpackage-dotnetcore

From there, instead of using the Sqlpackage.exe under C:\Program Files (x86), use the Sqlpackage.exe in C:\Temp\Sqlpackage-dotnetcore.

Command will be:

C:\Temp\Sqlpackage-dotnetcore>SqlPackage.exe /a:import /sf:D:\Exportedbacpac\my.bacpac /tsn:localhost /tdn:<target database name> /p:CommandTimeout=1200


No comments:

Post a Comment

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...