“收藏夹"或“宏"在 SQL Server 管理工作室? [英] "Favorites" or "macros" in SQL Server Management studio?

问题描述

我有几个数据库，我总是使用 SQL Server Management Studio.我希望能够创建一个工具栏按钮或键盘快捷键，自动打开一个新的查询窗口(在当前 SSMS 实例中)并连接到给定(可能已注册)的数据库.就是这样.这就是我所需要的.还有这个烟灰缸、桨游戏和遥控器.这就是我所需要的.

I have a few databases that I always use SQL Server Management Studio with. I'd like to be able to create a toolbar button or keyboard shortcut that automatically opens a new query window (in the current SSMS instance) and connects to a given (registered, perhaps) database. That's it. That's all I need. And this ashtray, and the paddle game, and the remote control. That's all I need.

现在，我必须展开对象资源管理器，折叠/展开两到八棵树，右键单击我的数据库，然后选择新建查询".我认为没有办法做到这一点，这可能会让我每天节省 30-60 秒.

As it is now, I have to expand the Object Explorer, collapse/expand two to eight trees, right-click on my database, and choose "New Query". I see no way to do it, this would probably save me 30-60 seconds a day.

推荐答案

我是 SSMSBoost 插件，它正是您所需要的:允许管理首选服务器/数据库列表，并通过工具栏上的自定义组合框在它们之间快速切换，您也可以说，如果您希望在 启动 时在 ObjectExplorer 中打开所有服务器，并且是否应该为它们打开一个新的查询窗口(每个服务器设置).

I am developer of SSMSBoost add-in and it has exactly what you need: is allows to manage the list of preferred servers/databases and quickly switch between them via custom Combobox on the toolbar, you can also say, if you want all servers to be opened in ObjectExplorer upon start-up and if a new query window should be opened for them (per-server setting).

SSMSBoost 还允许您定义别名(而不是 server8273128 > MainServer、server231232> BackupServer 等.)它具有更多功能 - 但它们超出了本主题的范围.

SSMSBoost also allows you to define aliases (instead of server8273128 > MainServer, server231232> BackupServer etc..) It has more features - but they are out of scope of this topic.

看图片 - 您可以看到 Quick Connection Switch 组合框与来自首选连接的一些服务器，SSMSBoostDemoServer" - 是服务器的别名，下一个名称 - 是原始的.

Look at the picture - you can see Quick Connection Switch combobox with some Servers from preferred connections, "SSMSBoostDemoServer" - is an alias for the server, next name - is original.

还有一件事 - 插件在免费版本中可用.

One more thing - add-in is available in free edition.

这篇关于“收藏夹"或“宏"在 SQL Server 管理工作室?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！