Click here to Skip to main content
15,503,367 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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??


What I have tried:

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.
Posted
Updated 3-Nov-21 0:25am

We cannot help you: we have no access to the project, the solution, or indeed any of the code.
We can't even see the compilation results!

Start with Visual Studio and look at the Error pane: what is in there? Look at the lines any error messages refer to.

A "slow build" of a large project the first time is to be expected (i.e. until you get a clean build) because it has to compile every file to produce intermediate object files it can later link together: subsequent builds only need to process the files that are affected by any changes and go much quicker.
 
Share this answer
 
Comments
prassin babu 3-Nov-21 4:39am    
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
6k objects seems excessive - I've worked on major financial systems that had fewer objects (unless you are classing every Index and every SP as an "object")

Without access to any meaningful information I would suggest creating a new empty project then importing the schema in "batches", building as you go and taking care on dependencies. Only after you have built the full project for the first time should you attempt to link it to TFS.

Potentially useful documents:
- Create a New Database Project - SQL Server Data Tools (SSDT) | Microsoft Docs[^]
- https://knowledgebase.apexsql.com/link-sql-server-database-team-foundation-server-repository/[^]
 
Share this answer
 
Comments
prassin babu 3-Nov-21 7:42am    
Thanks for the comment brother. The objects are schema depended. I have around 19 separate schemas in my project. Do we have any other settings in the project properties?
CHill60 4-Nov-21 8:04am    
Then introduce the objects into your new project one schema at a time
prassin babu 3-Nov-21 8:30am    
The Database project contains multiple database references in the stored procedures and functions. Is that a problem ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900