Visual Studio 2019 SQL Server DB project - Failed to deploy to local test instance under VS with SQL72014 and SQL72045

Question

I've created a SSDT DB Project under VS2019 and imported a SQL Server 2016 DB. After fixing some builds errors, I was able to get the project to build. However, when I tried to start debugging (with F5), I kept getting the error "Error: SQL72014: SQL Execution error: A fatal error occurred. Incorrect syntax was encountered while $(ESCAPE_NONE( was being parsed." and also "Error: SQL72045: Script execution error". Googling didn't help much. Any help would be greatly appreciated.

Answer 1

Hi @Phan, Huy (DSHS/OOS/TSD)

I don't know how your code looks like. I found a thread similar to yours: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/87039167-7bb6-42dc-b20e-0dabf9a3f44b/sql72014-sql-execution-error-a-fatal-error-occurred-incorrect-syntax-was-encountered-while-?forum=ssdt, maybe you can use it as a reference.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya