Preferred Connections Feature?

Caj0005

I'm now using the Prompt trial because SSMSBoost wants to charge me now for a feature that I can't function without now.
I'm thinking about buying Prompt for many reasons, but if there isn't a feature that stores server/dbname that I can easily shortcut to, or drop down from here, then they may have won and I'll have to buy the Pro version.

Am I missing a feature here? I've been everywhere and can't find anything about it.

Michael Clark

Hi @Caj0005,

We store saved tabs in a Sqlite database here in case you wanted to transfer to another machine:

C:\Users\<USERNAME>\AppData\Local\Red Gate\SQL Prompt 9\SavedTabs.db

Would it be possible to give that a try and see if that works for you?

Best,
Michael

Michael Clark

Hi @Caj0005,

Would it be possible to tell us a bit more about how this SSMSBoost feature works?

We have a Tab History feature that remembers your last used tabs/scripts and restores them and the connections when you restart SSMS. Would that suffice?

You can read more about Tab History here:
https://documentation.red-gate.com/sp9/navigating-your-code/tab-history

Best,
Michael

Caj0005

Hey yeah, tab history is a bit different.
The SSMS Boost feature allows you to save a connection to a server and db under a certain alias. Then there is an easily accessible list of those aliases in a drop down where searching is as easy as typing the first few letters of the alias and it begins filtering.
Example: Server Name: PASQL226
Database: AdventureWorks2016
Saved as (alias): ADV16
So there's a list of those "preferred connections" as they call it, which ties the server name and database to an alias and you just recall the alias and you connect.

Caj0005

Not sure if the image will load, but it looks like the closest thing you have that you could build off of is the Tabs > Color setting. Just add a column for Alias and a shortcut to access them.

Also, when you're connected to a certain DB on a server, SSMS boost lets you add whatever you're connected to at that time to the "preferred connections" list instead of adding it manually like you have to add the tabs color manually in SQL Prompt.

I guess you could integrate that option with a checkbox in Tab History to save that instance to a preferred connections list that also offers the tab color option.

Caj0005

tab history is similar...the more i work with it..but it isn't saving to my settings. something i could export for example if i needed to install sql on another machine.
it seems temporary like i could lose it if it runs out of memory