Skip to content
← SQL Search

How can we improve SQL Search?

SQL Search: Data search

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Ability to set default databases to search in

Give the users the ability to set default databases to search in, so that when ever the SQL Search is done, it saves them the time to select their mostly searched databases

95 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Nitin Bhojwani shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Gregory Bartlett commented  ·   ·  Report

    Red-Gate, please give us some sort of option to set so that it doesn't automatically search ALL databases, make me pick what I want to search vs auto selecting them all or as others noted, cache what was selected last.

  • Rob commented  ·   ·  Report

    I see this is an old post but am hoping this is still being considered for a feature.

    Aside from the longer indexing time to always index databases you are not interested in searching...
    We have multiple databases that not everyone has permissions to read from. When opening the search, it immediatly attempts to connect to all databases and adds a bunch of security events to the log which can trigger messages to the DBAs.

    Allowing this to remember which databases were indexed last time would really help in addressing this issue.

    A simpler option to implement would be to allow you manually start the indexing after selecting the list of databases to search.

  • Tim commented  ·   ·  Report

    We have about 40 client databases on our dev instances. Indexing takes 5 minutes to go through all of them. Super annoying. Being able to identify which databases (1 per developer in our case) to index would make the tool feasible to use.

  • Marco Montagni commented  ·   ·  Report

    not only: is annoying that SQL search always trying to search in ALL Object Type.
    Would be useful to set a default