You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, finding specific fragments or objects (like columns, parameters, or strings) across multiple databases in SSMS requires manual search operations via custom scripts. While those can be be accessed via the template feature, it would be nice to have a search feature built in. While free tools like Redgate SQL Search exist, having a native, lightweight version built directly into Axial SQL Tools would improve workflow and maintenance by keeping all essential DBA tools in one extension.
Idea
Implement a "Quick Search" panel that allows users to search for text across all objects in a server or selected databases. Basic features should include:
Search Scope: Capability to search through Stored Procedures, Views, Functions, Tables, etc. (just starting with those basic types would be great)
Filter Options: Ability to filter by "Match whole words only" and "Use wildcards" (as seen in the provided image), would be nice but not essential.
Results: A search results pane (as in the image) that displays the results highlights the match. Initially this could be similar to the Query History results grid.
Bonus: A "Select object in Object Explorer" link to jump directly to the result.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Currently, finding specific fragments or objects (like columns, parameters, or strings) across multiple databases in SSMS requires manual search operations via custom scripts. While those can be be accessed via the template feature, it would be nice to have a search feature built in. While free tools like Redgate SQL Search exist, having a native, lightweight version built directly into Axial SQL Tools would improve workflow and maintenance by keeping all essential DBA tools in one extension.
Idea
Implement a "Quick Search" panel that allows users to search for text across all objects in a server or selected databases. Basic features should include:
Search Scope: Capability to search through Stored Procedures, Views, Functions, Tables, etc. (just starting with those basic types would be great)
Filter Options: Ability to filter by "Match whole words only" and "Use wildcards" (as seen in the provided image), would be nice but not essential.
Results: A search results pane (as in the image) that displays the results highlights the match. Initially this could be similar to the Query History results grid.
Bonus: A "Select object in Object Explorer" link to jump directly to the result.
Beta Was this translation helpful? Give feedback.
All reactions