Skip to main content

SqlPackage - The Element or Annotation class SqlStatistic does not contain the Property class AutoDrop

· One min read
Max Nguyen
FinOps Ranger

If you are using d365fo.tools to Import a bacpac file into a Tier1 environment and you got an error

Error output was

Error importing database:An error occurred during deployment plan generation. Deployment cannot continue. The Element or Annotation class SqlStatistic does not contain the Property class AutoDrop.

The d365fo.tools use Invoke-D365InstallSqlPackage to install SqlPackage, but its version is not up to date, compare to the bacpac files generated from LCS database export. To solve the issue, we need to downlaod the latest version as a zip file, unblock, unzip and replace files in the SqlPackage folder C:\Temp\d365fo.tools\SqlPackage with the new version.