lennard
Reputation: 11
Visual Studio Deploy to SQL Data Warehouse Incorrect Syntax Near 'ANSI_NULLS'
I would like to deploy a Database Project in Visual Studio 2017 to Azure SQL Data Warehouse. Unfortunately each attempt fails with the following error message
Failed to import target model [database name]. Detailed message Parse Error at line: 1, column: 5: Incorrect Syntax near 'ANSI_NULLS'.
Connecting via SQL Server Object Explorer and simple querying are working fine. Do you have any suggestions how to solve this problem?
Thank you very much!
Upvotes: 1
Views: 396
Answers (1)
Ron Dunn
Reputation: 3078
Sorry, but Database Projects are not currently supported for Azure SQL Data Warehouse.
You might like to vote for it here:
Upvotes: 1
Related Questions
- Azure Synapse Serverless SQL Pool Error: Incorrect syntax near 'DISTRIBUTION'
- Dacpac deployment in azure refers value as invalid column name
- Error in Azure DevOps SQL Server database deploy task not failing pipeline
- TSQL: seemingly empty string
- Facing errors while SQL deployment in azure devops pipeline
- SQL Data warehouse: Incorrect syntax near 'OFFSET'
- Error in SSIS Packages loading data into azure data warehouse
- Cannot connect to Azure SQL Data Warehouse database-error "Incorrect syntax near 'ANSI_NULLS'"
- VSTS: Deploy Azure SQL DACPAC throws an error
- Deploying database to azure error SQL72014