blocks|key|2599027|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2599028|转到项目设置|ordered-list-item|offset|length|style|BOLD|2599029|，单击操作选项卡下的数据库设置按钮|2599030|2599031|2599032|3.1取消选中Auto+create+statictics和|2599033|3.2取消选中Auto+update+statistics复选框。|2599034|这将使您的操作数量减少约90%25，分析应立即完成。|2599035|entityMap^0|0|2|4|0|3|5|A|5|0|0|0|7|M|0|7|M|0|0^^$0|@$1|2|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|U|7|@$D|V|E|W|F|G]]|8|@]|9|$]]|$1|H|3|I|4|C|6|X|7|@$D|Y|E|Z|F|G]|$D|10|E|11|F|G]]|8|@]|9|$]]|$1|J|3|-4|4|C|6|12|7|@]|8|@]|9|$]]|$1|K|3|-4|4|5|6|13|7|@]|8|@]|9|$]]|$1|L|3|M|4|5|6|14|7|@$D|15|E|16|F|G]]|8|@]|9|$]]|$1|N|3|O|4|5|6|17|7|@$D|18|E|19|F|G]]|8|@]|9|$]]|$1|P|3|Q|4|5|6|1A|7|@]|8|@]|9|$]]|$1|R|3|-4|4|5|6|1B|7|@]|8|@]|9|$]]]|S|$]]

<ol>
<li>Go to Project Settings </li>
<li>click on the Database Settings button</li>
<li>Under the Operational tab

3.1 uncheck Auto create statictics and 

3.2 Uncheck Auto update statistics checkbox. </li>
</ol>

This will reduce your numbers of operations by about 90% and the analysis should finish instantly.

blocks|key|1920991|text|这个问题有点老了，但当你寻找解决方案时，这个问题首先会出现，所以我会补充我的2分钱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1920992|如果你在安装补丁后仍然有这个问题，试试这个，这对我很有效：|1920993|在Windows资源管理器中打开数据库项目文件夹。删除以下文件/文件夹：|1920994|1920995|在根目录中，.dbmdl文件|unordered-list-item|1920996|
|1920997|+"sql“目录的内容|1920998|1920999|+obj目录。|1921000|1921001|关闭并重新打开Visual+Studio。单击Build。|1921002|这个项目对我来说做得很好。|1921003|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|13|8|@]|9|@]|A|$]]|$1|N|3|K|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|P|5|I|7|15|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|17|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|18|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|W|$]]

This question is a bit old but this comes up first when you search for a solution, so I will add my 2 cents.

If you still have this problem after installing the fix, try this, this worked for me:

Open the database project folder in Windows Explorer. Delete the following files/folders:

<ul>
<li>in the rootdirectory, the .dbmdl file </li>
<li>the content of the "sql" directory </li>
<li>the obj directory.</li>
</ul>

Close and re-open Visual Studio. Click Build. 

The project built fine for me.

blocks|key|8123|text|老问题，但看起来仍然没有解决。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8124|我的dacpac有超过10000个对象，构建在验证阶段卡了40多分钟。我尝试了其他评论和答案中提出的选项，但没有找到joy。|8125|显然，模型的验证也进行了“案例搜索”。我取消选中该选项，构建时间下降到不到一分钟。|8126|Validate+Casing+on+identifies+in+SQL+Server+project+in+VS2017+|offset|length|8127|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/aPBZ9.png^0|0|0|0|0|1Q|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

Old question, but looks like still not solved.

My dacpac has over 10000 objects and the build got stuck for over 40 mins on the Validating stage.
Tried the options suggested in other comments and answers but no joy.

Apparently, the Validation of the model also does a "case search". 
I unchecked the option and build time dropped to under a minute.

<a href="https://i.stack.imgur.com/aPBZ9.png" rel="noreferrer">Validate Casing on identifies in SQL Server project in VS2017 </a>

blocks|key|1914435|text|根据SQL+Server数据层应用程序框架2013年3月更新的发行说明，此错误现在应该已修复。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1914436|Visual+Studio中的|1914437|数据库项目挂起于“分析数据库架构…”此版本解决了加载或构建大型数据库项目时可能出现的问题。在某些情况下，操作永远不会完成。这是一个功能修复，而不是性能增强-即使有了修复，完成此操作的时间也取决于项目的大小和复杂性|blockquote|1914438|1914439|1914440|http://blogs.msdn.com/b/ssdt/archive/2013/03/06/sql-server-data-tier-application-framework-march-2013-available.aspx|offset|length|1914441|http://www.microsoft.com/en-us/download/details.aspx?id=36842|1914442|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|0|0|0|38|0|0|0|1P|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@$K|12|L|13|1|14]]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@$K|16|L|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|J]]|V|$5|R|S|T|A|$U|N]]]]

According to the release notes of the March 2013 update of SQL Server Data-Tier Application Framework, this bug should be fixed now.

<blockquote>
 Database Project in Visual Studio hangs on “Analyzing Database Schema…” This release addresses an issue that can occur when loading or building large Database Projects. In some cases, the operation would never finish. This is a functional fix, not a performance enhancement - even with the fix, the time to complete this operation depends on the size and complexity of your project
</blockquote>

<a href="http://blogs.msdn.com/b/ssdt/archive/2013/03/06/sql-server-data-tier-application-framework-march-2013-available.aspx" rel="noreferrer">http://blogs.msdn.com/b/ssdt/archive/2013/03/06/sql-server-data-tier-application-framework-march-2013-available.aspx</a>

<a href="http://www.microsoft.com/en-us/download/details.aspx?id=36842" rel="noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=36842</a>

blocks|key|2599212|text|分析数据库对象(在VS+2015+Update+3中)花费的时间比平时多，并且是在重复尝试重新启动VS之后发生的。我怀疑当对象的数量在15分钟内没有变化时，会出现挂起的情况。对我来说，下面的内容让我重新开始了；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2599213|2599214|Close+VS+|ordered-list-item|2599215|制作解决方案文件(*.sln)的备份副本|2599216|编辑解决方案文件，删除数据库项目Restart+VS。我发现我现在能够打开解决方案并构建|2599217|，关闭解决方案，并使用原始备份|2599218|Restart+VS替换您编辑的解决方案文件。我发现这次打开了解决方案，并且我能够构建successfully|2599219|2599220|希望这能帮助和我处于同样境地的人。|2599221|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|X|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|Y|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

Analyzing database objects (in VS 2015 Update 3) was taking more time than usual, and was occurring after repeated attempts at restarting VS. I suspect things had hung when the number of objects hadn't changed for 15 minutes. For me, the following got me going again;

<ol>
<li>Close VS</li>
<li>Make a backup copy of the solution file (*.sln)</li>
<li>Edit the solution file, removing the database projects Restart VS. I
found that I was able to now open the solution and build </li>
<li>Close the solution and replace your edited solution file with the original
backup </li>
<li>Restart VS. I found that the solution opened this time, and I was able to build successfully</li>
</ol>

Hopefully this helps someone in the same spot that I was in.

blocks|key|4711717|text|如果SSDT项目不是您经常使用的项目(就像我的例子一样)，那么您可以卸载该项目，并将其保留为未加载。这样，在Visual+Studio中打开解决方案就不需要时间了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4711718|当您需要在SSDT项目中执行某些操作时，此时可以重新加载该项目。|4711719|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If the SSDT project is not something that you use all the time (like in my case), you can Unload the project, and leaved it unloaded. This way opening the solution in Visual Studio takes no time.

When you need to do something in the SSDT project, at that time you can Reload the project.

blocks|key|2599012|text|这是一个可能的修复方法。(由于速度问题，我以前不得不在SQL数据库上重新创建模式)，但这篇文章可能值得一看。-听起来更接近你的问题。Can't+open+my+dbml+file+in+Visual+Studio+2010+anymore|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2599013|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/6918046/cant-open-my-dbml-file-in-visual-studio-2010-anymore^0|1U|1H|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Here is a possible fix. (I have had to recreate the schema on SQL databases before, due to speed issues) but this article might be worth looking at. - sounds closer to your issue.
<a href="https://stackoverflow.com/questions/6918046/cant-open-my-dbml-file-in-visual-studio-2010-anymore">Can&#39;t open my dbml file in Visual Studio 2010 anymore</a>

blocks|key|1914538|text|对于这种情况，如果您不想将其(sql文件)包含在项目构建中，请在创建文件时选择"Not+in+build“选项或更改sql文件属性Build+=+"None”。这将对.sqlproj文件进行更改，并需要重新启动visual+studio。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1914539|它为我修好了，救了我的命！|1914540|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

For this case, if you wouldn't include it (sql files) in project build, choose option "Not In Build" when creating file(s) or change sql file property Build = "None". That will make changes against .sqlproj file and visual studio restart required.

That fixed for me and saved my life!

blocks|key|8155|text|我甚至在Visual+Studio2019企业版16.3.2中遇到了这个问题。我只需删除本地数据库项目，并递归地从DevOps代码库中获取项目的最新版本，就解决了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8156|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I even had this issue with Visual Studio 2019 enterprise version 16.3.2
I solved it by just deleting my local database project and fetched the latest version of the project recursively from my DevOps code repository

blocks|key|1921151|text|请尝试关闭Visual+Studio并删除解决方案根目录中的.vs文件夹。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1921152|(VS只是在您下次运行它时重新创建它，尽管您可能需要再次设置您的启动项目)。|1921153|entityMap^0|U|3|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Try closing Visual Studio and deleting the .vs folder in the root of your solution.
(VS just recreates it next time you run it, though you may need to set your Startup Project again).

Using a new SQL2005 database project in VS2010.
I did import objects and settings, and built the project.
It seems to be stuck at 'Analyzing database schema. Your database projects will be ready after 3267 operations are completed'.

This seems to take hours. 
Is there any way to speed this up?

I read somewhere that this may happen if my .dbmdl file is too big, but it's just 2.6MB.

Analyzing database schema takes hours

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

在VS2010中使用新的SQL2005数据库项目。我确实导入了对象和设置，并构建了项目。它似乎停留在“分析数据库模式。你的数据库项目将在3267操作完成后准备好”。这似乎需要几个小时。有没有什么方法可以加快速度呢？我在某处读到，如果我的.dbmdl文件太大，可能会发生这种情况，但它只有2.6MB。

问分析数据库模式需要几个小时
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问分析数据库模式需要几个小时EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问分析数据库模式需要几个小时
EN