Search

SSDT: SQL Server Object Explorer: Object Search by Branko K

Resolved
as Won't Fix Help for as Won't Fix

2
0
Sign in
 to vote
Type: Suggestion
ID: 775710
Opened: 1/3/2013 10:29:30 AM
Access Restriction: Public
0
Workaround(s)
I am using SSDT Dec 2012 release with VS2010.

I find it very inefficient, time consuming and difficult to find an object (table, sp, etc) in the SQL Server Object Explorer when working in the connected mode and on a large database. Since I rely on the Red Gate SQL Search in the SSMS I cannot switch to VS2010 Database Connected development.

Similarly, when I try to find an object file in the SQL Project there is no user friendly and interactive search to quickly find an object in the project. Existing Find and Find In Text helps, but it does not clearly outline the object files. Instead, the file names are part of the text search results and not that easy to spot.
Details (expand)

Product Language

English

Category

Developer Tools (SSDT, BIDS, etc.)

Proposed Solution

It would be really useful as soon you start typing any part of the object name a search textbox to appear with the search criteria in it and start narrowing down your results in your selected database node. In addition to this Quick Search functionality, an SSMS Object Explorer Filter functionality would be a nice complementary feature for a more specific searches.

I believe that Visual Studio 2010 Power Tools have a functionality like that in the C# Object Explorer view.

A similar search functionality would be useful in the Solution Explorer to help find quickly objects to work on by the partial search on the object name rather than to rely on the Find or Find In Files to look for the name occurences in the sql scripts.

Primary Benefit

Faster Development

Other Benefits

The benefit of a search functionality would be:

- to find quickly objects to work on
- to clearly outline object with names matching the criteria
- to enable a partial object name search

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 1/17/2013 at 10:44 AM
Thanks for the input. This will be considered for a future version of SSDT.
Posted by Microsoft on 1/17/2013 at 10:26 AM
We understand the issue and is under consideration.
Posted by Jamie Thomson on 1/3/2013 at 10:47 AM
Completely agree. SSOX needs search.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement