What are the challenges you face when working across database platforms? Take the survey
Options

Preferred Connections Feature?

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.

Tagged:

Best Answer

  • Options
    Michael ClarkMichael Clark Posts: 123 Silver 4
    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
    Technical Lead, SQL Monitor

Answers

  • Options
    Michael ClarkMichael Clark Posts: 123 Silver 4
    edited December 22, 2017 3:15PM
    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? :smile:

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

    Best,
    Michael
    Michael Clark
    Technical Lead, SQL Monitor
  • Options
    Caj0005Caj0005 Posts: 4 New member
    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.


  • Options
    Caj0005Caj0005 Posts: 4 New member
    edited December 22, 2017 4:56PM
    8wxhhoc9rtey.png

    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.

    61y6w0aeprlb.png

  • Options
    Caj0005Caj0005 Posts: 4 New member
    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
Sign In or Register to comment.