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
Gregory Bartlett commented
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.
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.
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
not only: is annoying that SQL search always trying to search in ALL Object Type.
Would be useful to set a default