Database project first build taking long time and not able to build

Question

Database project first build taking long time and not able to build

Prassin Babu 1

I have created a new database project for my large application using visual studio 2019. There are more than 6k object belongs to the database. When I trying to build the project it is taking long time and not able to build. There is any build errors in the project file. The DB project created under TFS. I have updated the statistics for the system tables and unchecked Auto Created statistics and Auto Update statistics under Project property operational tab but still not getting done the build. Can someone please help me to solve this problem??

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2021-11-04T22:14:38.653+00:00

Hi @PrassinBabu-5717 Thanks for posting your question on Microsoft Q&A. Sorry about your issue

Are you trying to build a database targeting Azure SQL Database in Visual Studio. Could you please share error message you are getting.?

Regards,
Oury
Prassin Babu 1 Reputation point

2021-11-05T06:02:40.717+00:00

So far there is no error. The build progress stuck and not able to build. The progress output given below.

There is no build error its seems
Build started...
------ Build started: Project: DBProject, Configuration: Debug Any CPU ------
The project model is not yet complete. The build will continue after the project model has been successfully populated.
Loading project references...
Loading project files...
Building the project model and resolving object interdependencies...
Validating the project model...
This is what I Am seeing in the output box. I am able to build the solution without TFS.

The status showing "Your database project will be ready after 31145 operations are completed (Stuck in this state more than 2 hrs)

1 answer

Your answer

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2021-11-04T22:14:38.653+00:00

Hi @PrassinBabu-5717 Thanks for posting your question on Microsoft Q&A. Sorry about your issue

Are you trying to build a database targeting Azure SQL Database in Visual Studio. Could you please share error message you are getting.?

Regards,
Oury
Prassin Babu 1 Reputation point

2021-11-05T06:02:40.717+00:00

So far there is no error. The build progress stuck and not able to build. The progress output given below.

There is no build error its seems
Build started...
------ Build started: Project: DBProject, Configuration: Debug Any CPU ------
The project model is not yet complete. The build will continue after the project model has been successfully populated.
Loading project references...
Loading project files...
Building the project model and resolving object interdependencies...
Validating the project model...
This is what I Am seeing in the output box. I am able to build the solution without TFS.

The status showing "Your database project will be ready after 31145 operations are completed (Stuck in this state more than 2 hrs)

Answer 1

Oblio 51

I've also had this problem. I created a new project based on an existing database. Opening the project in VS2019 leads it to hang at the "will be ready" phase and consumes so much system resources that I have to close VS.

Other notes:

I have installed VS2022 and experience the same issue.
I've installed the VS Code extension "SQL Server" and the project hangs during "Building the project model" step.
Apparently, the VS Pro subscription does not include support for this. I can only speculate it's because it depends on SSDT in the background.

Overall, it appears the MS's tools in this area are an absolute failure and this bug has been around for almost a decade.

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-03-14T19:23:54.43+00:00

@Oblio Could you please open a support ticket, so we further investigate what is causing this behavior.

Regards,
Oury
Oblio 51 Reputation points

2022-03-14T20:51:21.973+00:00

I'd love to, but when I tried, it said my VS Pro license didn't have an eligible support plan associated with it. I don't know if this is because I specified SSDT, or what.
Prassin Babu 1 Reputation point

2022-03-16T06:11:02.697+00:00

I am still facing this issues. How can I open support ticket for this?
StingyJack 131 Reputation points

2023-03-10T17:57:11.95+00:00

Apparently, the VS Pro subscription does not include support for this. I can only speculate it's because it depends on SSDT in the background.

This is not true. I use VS Pro and am able to work with SQL projects, and use the data and schema comparison tools often (based on SSDT/DacFX).

Share via

Database project first build taking long time and not able to build

1 answer

Your answer