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.
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
August 23, 2023 at 9:49 pm
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:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy