Visual Studio 2017 的架构差异超时问题 [英] Schema Diff Timeout issue with Visual Studio 2017

问题描述

使用 Visual Studio Pro 2017 对 2 个数据库执行架构差异时，我面临架构差异超时问题，因为服务器中的数据库太大，因此结果始终显示未检测到差异.

When perform schema diff for 2 databases with Visual Studio Pro 2017, I'm facing with issue about schema diff timeout because the database in server too large, so the result always display no differences detected.

在 Visual Studio 2015 中，我可以通过增加 regedit 中的QueryTimeoutSeconds"来解决，它可以正常工作.但是当升级到 Visual Studio 2017 时，我找不到任何地方有这个值

With Visual Studio 2015, I can workaround by increasing the "QueryTimeoutSeconds" in regedit and it's working as normally. But when upgrade to Visual Studio 2017, I can't find anywhere have this value

有没有人遇到过这个问题并有任何解决方法?

Have anyone experiance with this issue and have any solution workaround?

我的环境:- SQL Server 2017 开发人员- Visual Studio 2017 专业版- SSDT 15.1.61710.120

My environment: - SQL Server 2017 Developer - Visual Studio 2017 Pro - SSDT 15.1.61710.120

推荐答案

经过更多的调查，我发现在 Visual Studio 2017 中，我们可以在 regedit 中更新 QueryTimeoutSeconds ，但是由于 Visual Studio 需要一点配置2017 年已经出现了 regedit.

After more investigation, I found that in Visual Studio 2017, we can updating QueryTimeoutSeconds in regedit, but a little configuration because Visual Studio 2017 already hive the regedit.

首先，请关闭所有 Visual Studio 2017 应用程序，然后打开 regedit 应用程序.

First, please close all Visual Studio 2017 application, after that, open regedit application.

选择HKEY_LOCAL_MACHINE，点击File，选择Load Hive，将链接粘贴到地址:%LOCALAPPDATA%\Microsoft\VisualStudio\，选择15.xxx 并选择privateregistry.bin -> 点击Open.

Choose HKEY_LOCAL_MACHINE, click File and choose Load Hive, and paste the link to address: %LOCALAPPDATA%\Microsoft\VisualStudio\, select 15.xxx and choose privateregistry.bin -> Click Open.

在出现的对话框中输入VS_2017_LoadHive，点击OK.

Input VS_2017_LoadHive in the appeared dialog and click OK.

展开 HKEY_LOCAL_MACHINE >VS_2017_LoadHive，在SQLDB>下找到QueryTimeoutSeconds键数据库，之后将值增加到6000.之后，选择File 并选择Unload Hive.

Expand HKEY_LOCAL_MACHINE > VS_2017_LoadHive, and find QueryTimeoutSeconds key under SQLDB > Database, after that increased the value to 6000. After that, select File and choose Unload Hive.

再次打开 Visual Studio 2017 并享受.

Open Visual Studio 2017 again and enjoy.

这篇关于Visual Studio 2017 的架构差异超时问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！