Hi expert
I have a fresh cloud-hosted dev machine with the last version 10.0.22 and try to import the .backpac file using sqlpackage .NET Core for Windows and i get this error during import
*** Error importing database:Could not import package. Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY'. Error SQL72045: Script execution error. The executed script: IF EXISTS (SELECT 1 FROM [master].[dbo].[sysdatabases] WHERE [name] = N'$(DatabaseName)') BEGIN ALTER DATABASE SCOPED CONFIGURATION SET ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY = ON; ALTER DATABASE SCOPED CONFIGURATION SET GLOBAL_TEMPORARY_TABLE_AUTO_DROP = OFF; END
I solve this issue by getting a new database backup from LCS
Hi Alex VN,
I always used this version 18.7 and always works very well except this time because in this time I use cloud dev machine 10.0.22 with SQL server 2019.
did you try it with this dev machine?
Thanks, Judy Jee and Alex VN for your reply
but I face the same issue
Hi,
I would suggest you to change sqlpackage .net version that you used to import the bacpac. Normally 18.4 is the most stable one that I mostly used.
docs.microsoft.com/.../release-notes-sqlpackage
Hope it helps.
Hi source,
Which version of .Net Core are you using?Please refer to the old thread to see if it helps:
community.dynamics.com/.../import-bacpac-file-exported-from-uat-to-devops---create-user-syntax-error
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 895
Sohaib Cheema 811 User Group Leader
André Arnaud de Cal... 787 Super User 2025 Season 2
