ApexSQL Search

This is a tool to analyze dependencies of SQL Server database objects.

ApexSQL Search analyzes SQL Server database objects` dependencies. The search for dependencies can be within a database, across databases, scripts and applications. This program is capable of finding the dependencies that SQL server itself may not be able to find. It lets you search for objects or text in database object definitions. The text search will let you search for text, numbers, dates and unique identifiers in your tables and views. This tool will help you visualize the complex relationships between database objects. This program lets you search directly in SSMS and VS. You can then quickly find data in tables, views, and relationships between objects. You can rename objects without corrupting the relationships and the dependencies.

Search history feature lets you find previously searched objects. This history is created by automatically saving the previous searches. Customizable searches are possible. Search results can be easily grouped, sorted and filtered. Quick navigation to the data found is possible in one click. The program allows search, rename and identify encrypted objects. Smart renaming without breaking dependencies is another important feature. Tables, procedures, views, columns, functions are some of the things you could rename. It is compatible with SQL Server 2012, 2008 R2, 2008 and 2005 objects and data types. You would be able to find data quickly stored in tables and views. Even the most complex database can be decomposed into easy to comprehend relationship diagrams. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

ApexSQL Search analyzes SQL Server database objects' dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly in SSMS and VS, quickly find data in SQL tables and views, visualize complex relationships between objects, rename SQL objects without breaking dependencies.
Features:
- SQL objects’ extended properties can now be edited visually using the extended property editor
- Query editor tabs are automatically renamed to reflect their content in order to facilitate navigation between multiple open query editor tabs
- SQL Server 2012 support: Search for objects or text directly in SQL Server 2012 Management Studio including FileTables, sequences and search property lists. Smart rename SQL Server 2012 objects including FileTables
- Object search: Search for objects or text in database object definitions
- Text search: Search for text, numbers, dates and unique identifiers in your tables and views
- Graphical dependencies: Visualize even the most complex relationships between SQL objects
- Smart rename: Rename tables, procedures, views, functions and columns without breaking dependencies
- Search history: Quickly access previously searched objects with automatically saved searches
- Accurate analysis: Recognize all object interdependencies; even the ones SQL Server itself fails to identify
- Customizable searches: Specify the object types to be searched
- Quick navigation: Navigate to the found object in a single click
- Results browsing: Group, sort and filter search results
- Transparent description: Search, rename or identify encrypted objects dependencies. Search for data in encrypted views
- Visual Studio integration: Supports Visual Studio 2012, 2010, 2008 and 2005
- Support for all SQL Server versions: Full support for SQL Server 2012, 2008 R2, 2008 and 2005 objects and data types