Database schema analysis continuously in progress for a database project in Visual Studio

Question

Database schema analysis continuously in progress for a database project in Visual Studio

pmscorca 1,052

Hi, I'm developing a database project with Visual Studio 2022 and SSDT extension. After some scripts created I've noticed that Visual Studio runs more slowly because a database schema analysis is in progress, reading the message shown in the status bar: the database projects are ready after the completion of some thousands of operations. Is it possible to disable a such analysis at design time in order to work in Visual Studio without any slowdowns? Thanks

2 answers

Your answer

Answer 1

Tianyu Sun-MSFT 34,436 Microsoft External Staff

Hello @pmscorca ,

Welcome to Microsoft Q&A forum.

Do these three settings work(Disable code analysis - .NET Framework projects)? Please right-click you project > Unload Project > right-click it again > Edit Project File > add three lines into one of the property groups > right-click your project > Reload Project.

Besides, please try to right-click your project > Properties > Project Settings > uncheck Validate casing on identifiers option.

Other options maybe also work: right-click your project > Properties > Project Settings > Database Settings… > Operational > uncheck Auto create statistics and Auto update statistics options. Refer to documents: AUTO_CREATE_STATISTICS option, and AUTO_UPDATE_STATISTICS option.

BTW, database schema analysis runs by default, it has reasons. Actually, I don’t suggest changing/unchecking some specific options. If it’s very slow on your side, you may send feedback here: SQL or here: Developer Community - Visual Studio.

Sincerely,

Tianyu

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

pmscorca 1,052 Reputation points

2024-01-15T10:37:28.4066667+00:00

Hi, I'm maintaining the Build setting for Build Action option for each .sql file. In the output I've noticed more messages as this "Object reference not set to an object instance". So, do I need to add a database reference in the project also at design time? Can I author script file also without a database reference? The name of the target database is different than the name of the project.
Tianyu Sun-MSFT 34,436 Reputation points Microsoft External Staff

2024-01-22T09:59:24.82+00:00

Hi @pmscorca ,

You can set Build Action to None when you developing your projects, but you still need to change them back when you build/compile your project. As the build action controls what happens to the file when the project is compiled.

Do I need to add a database reference in the project also at design time? Can I author script file also without a database reference?

I may suggest you wait for the double confirmation from SQL Server team. In my opinion, the database reference is needed.

If you got errors when you changed it(without a database reference), then probably it means they are needed.

Kind Regards,

Tianyu
pmscorca 1,052 Reputation points

2024-01-22T15:36:43.1266667+00:00

Hi, reviewing the SQL code I've noticed some IF EXISTS or IF NOT EXISTS before the CREATE TABLE statements; so I've removed these IF and the issue has been solved. Thanks

Answer 2

Pinaki Ghatak 5,600 Microsoft Employee Volunteer Moderator

Hello @pmscorca

Yes, it is possible to disable the database schema analysis in Visual Studio 2022 to avoid slowdowns. Here are the steps to do so:

Right-click the project node in Solution Explorer and select Properties.
Select the Code Analysis tab.
To disable source analysis at build time, uncheck the Run on build option.
To disable live source analysis, uncheck the Run on live analysis option.

Please note that starting in Visual Studio 2022 version 17.0.4, if you prefer the on-demand code analysis execution workflow, you can disable analyzer execution during live analysis. You may also look into using Azure Data Studio, for SSDT projects. The SQL Database Projects extension in Azure Data Studio provides a project-based development environment compatible with SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse SQL. It allows you to create a new project from a connected database, edit a project by adding or removing objects (tables, views, stored procedures) or custom scripts in the project, and more. However, please note that the SQL Database Projects extension requires the .NET SDK for project build functionality. I hope this helps!

pmscorca 1,052 Reputation points

2024-01-13T19:13:10.3+00:00

Hi, I'm working with Visual Studio Enterprise 2022 vers. 17.8.3 and the data platform destination is Azure SQL Data Warehouse. Navigating to the Solution Explorer --> Properties --> Code Analysis tab I cannot see any Run on live analysis option while I can see the Enable code analysis on build option.
Pinaki Ghatak 5,600 Reputation points Microsoft Employee Volunteer Moderator

2024-01-13T19:19:41.1033333+00:00

Hello again: Are you not able to see this on your Visual Studio 2022?, you right-click on the Project node, not the solution node.
pmscorca 1,052 Reputation points

2024-01-13T19:29:55.2133333+00:00

In Visual Studio I open my solution, in solution explorer I select the project node and right-click on properties voice: on the left I cannot see Code Analysis voice and the two All analyzers and .NET analyzers sub voices. I'm working with a database project by the SSDT extension.
pmscorca 1,052 Reputation points

2024-01-14T06:37:53.7766667+00:00

Hi, I've also read this article but it seems not much useful Database Project Settings - SSDT
pmscorca 1,052 Reputation points

2024-01-15T08:43:05.17+00:00

Hi, an update: it seems that choosing "None" setting for the Build Action option for each .sql file the code analysis is not executed; by default, this option is set to Build value. So, during the SQL code authoring is it right having the Build Action option equals to None?
Has anynone worked by Visual Studio 2022 + SSDT extension to create a database project, in particular versus a Synapse dedicated SQL pool?

Share via

Database schema analysis continuously in progress for a database project in Visual Studio

2 answers

Your answer