SQL Server Management Studio -- 工具/导入和导出设置菜单在哪里？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5586811/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server Management Studio -- where is Tools/Import and Export settings menu?
提问by tempid
In Visual Studio, there is an Import and Export settingswizard which you can use to customize Visual Studio and save settings to a .settings file.
在 Visual Studio 中，有一个导入和导出设置向导，可用于自定义 Visual Studio 并将设置保存到 .settings 文件。
Do we have something like it in SQL Server Management Studio?
我们在 SQL Server Management Studio 中有类似的东西吗？
I'm constantly switching between several VM's and configuring each SSMS is a pain in the neck. I want to be able to save my settings to a file, then import it in all my VM's.
我经常在几个虚拟机之间切换，配置每个 SSMS 是一件令人头疼的事。我希望能够将我的设置保存到一个文件中，然后将它导入到我所有的 VM 中。
Thank you.
谢谢你。
采纳答案by Dan J
Looks like MS has (essentially) acknowledged that, if this did exist, it's gone and there are no firm plans to bring it back...
看起来 MS 已经（基本上）承认，如果这确实存在，它就会消失，并且没有确定的计划将其带回来......
Hi Doug, Thank you for your suggestion to import/export settings for the R2 release. We will not be considering this for R2. We have this request already on file and we'll look at it for a future release beyond R2 to address this request.
嗨 Doug，感谢您建议为 R2 版本导入/导出设置。我们不会为 R2 考虑这个。我们已将此请求存档，我们将在 R2 之后的未来版本中查看它以解决此请求。
Unfortunate.
不幸的。
回答by Grzegorz Gierlik
Tools/Import and Export settingsmenu option disappeared from my menubar too (both for 2005 and 2008 SSMS versions), but I had and used it on my previous machine.
工具/导入和导出设置菜单选项也从我的菜单栏中消失了（2005 和 2008 SSMS 版本），但我在我以前的机器上使用过它。
For now I copy my archived settings to destination like c:\Documents and Settings\gg\Moje dokumenty\SQL Server Management Studio Express\Settings\CurrentSettings-2008-09-30.vssettings.
现在我将我的存档设置复制到目的地，如c:\Documents and Settings\gg\Moje dokumenty\SQL Server Management Studio Express\Settings\CurrentSettings-2008-09-30.vssettings.
And it works.
它有效。
回答by nbulba
The Studio keeps it's settings in the registry *HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server[version of SQL Server]\Tools\Shell*. For your scenario you could export appropriate settings on one computer and deploy the reg file to any other.
Studio 将其设置保存在注册表 *HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server[SQL Server 的版本]\Tools\Shell* 中。对于您的方案，您可以在一台计算机上导出适当的设置并将 reg 文件部署到任何其他计算机。
Hope it helps!
希望能帮助到你！
回答by HappyTown
Old question, but if someone still looking for, I checked SQL 2012, Tools > Import and Export settings wizard has re-appeared. Also present in SQL 2014 and 2016.
老问题，但如果有人还在寻找，我检查了 SQL 2012，工具 > 导入和导出设置向导重新出现。也存在于 SQL 2014 和 2016 中。
