SQL Object and data search, smart renaming and visual dependencies – Sneak Peek – ApexSQL Search

ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in which finds text in SQL database objects and data in SQL database tables and views. It allows changing table, view, stored procedure, function, column and parameter names and schema without breaking dependencies and visualizes all objects’ interdependencies

Here’s a quick look at the product’s features:


Object search

Search for objects or text in database object definitions

Object definitions

Text search

Search for text, numbers, dates and unique identifiers in your tables and views

Graphical dependencies

Visualize complex relationships between objects

Visualize complex relationships

Smart rename (code refactor)

Rename tables, procedures, views, functions and columns with no risk or problems

Rename tables

Customizable searches

Specify the scope of your search for both objects and data

Objects and data

Accurate dependency processing

Determine all objects’ dependencies including those that SQL Server itself fails to identify

Objects dependencies

Renaming impact analysis

See a list of warnings, the sequence of actions which will be taken and the objects impacted after renaming

List of warnings

Detailed results

View detailed information for each found record in data searches

Detailed information

Quickly access previously searched objects with automatically saved searches

Results browsing

Group, sort and filter search results

Sort and filter

Quick navigation

Navigate to the found object in Object Explorer with a single click

Object Explorer

Visual Studio integration

Supports Visual Studio 2010, 2008 and 2005

Support for SQL Server 2012, 2008 R2, 2008 and 2005

Full support for SQL Server 2012, 2008 R2, 2008 and 2005 objects and data types

July 19, 2012