SQLPackage Import Error

• JanM-66

  Ten Centuries

  Points: 1247

  More actions

  August 23, 2023 at 3:54 pm

  Go to Answer

  #4269267

  Hi

  After 1h the import fails with the error: Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 155, Level 15, State 1, Line 3 'AUTO_DROP' is not a recognized CREATE STATISTICS option.

  SQL Server 2019: 15.0.4316.3

  sqlpackage.exe: 162.0.52.1

  May the sqlpackage is to new but I didn't find the one who fits exactly.

  Thanks for your help.

• Eddie Wuerch

  SSChampion

  Points: 12541

  More actions

  August 23, 2023 at 6:23 pm

  Answer

  #4269358

  CREATE STATISTICS ... WITH AUTO_DROP is only available on AzureSQLDB, Azure Managed, and SQL2022.

  The package was created with the wrong target SQL Server version.

  Eddie Wuerch
  MCM: SQL

• JanM-66

  Ten Centuries

  Points: 1247

  More actions

  August 23, 2023 at 9:49 pm

  #4269487

  Yes correct, but source generation can not be changed.

  For those familiar with D365fO, Tier-2 DB Export produces .bacpac with new feature.

  You can fix the .bacpac with these steps:

  • extract model.xml from .bacpac.zip
  • use ps script to update the model.xml https://gist.github.com/FH-Inway/f485c720b43b72bffaca5fb6c094707e
  • sqlpackage import with param -mfp model.xml