Error importing Azure Synapse database into Visual Studio

Question

Hello! I need to connect Azure Synapse database to Azure DevOps for deploy it to my production environment. To do it I need to link Synapse database to Git within Visual Studio using a SQL Server Database project. I'm using VS 2017 and I'm getting the following error: "The server version or database compatibility level is not sypported". What does it means? How can avoid it? ![41617-fb-img-1605980242748.jpg][1] [1]: /api/attachments/41617-fb-img-1605980242748.jpg?platform=QnA

Answer 1

Hello anonymous user,

Welcome to the Microsoft Q&A platform.

Using SSDT for VS 2017- Azure Synapse Analytics (supports queries only; database projects aren't yet supported).

I would suggest you to use SSDT for VS 2019.

Visual Studio 2019 SQL Server Data Tools (SSDT) is a single tool allowing you to do the following:

• Connect, query, and develop applications
• Leverage an object explorer to visually explore all objects in your data model including tables, views, stored procedures, and etc.
• Generate T-SQL data definition language (DDL) scripts for your objects
• Develop your data warehouse using a state-based approach with SSDT Database Projects
• Integrate your database project with source control systems such as Git with Azure Repos
• Set up continuous integration and deployment pipelines with automation servers such as Azure DevOps

Reference: Getting started with Visual Studio 2019 and New in Azure Synapse Analytics: CICD for SQL Analytics using SQL Server Data Tools.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.