Redgate Test Data Manager

Improve your release quality and reduce your risk, with the flexibility to fit your workflow

Flyway

Automate database deployments across teams and technologies

Redgate Monitor

Understand server performance in an instant with fast deep-dive analysis

See all our products

Overview

Redgate’s end-to-end Database DevOps solutions

Test Data Management

Reliable test data management, automating repetition out of the process

Automate

Automate and accelerate your database change management workflow

Monitor

Monitor your cross-database, multi-platform estate to ensure optimal performance

SQL Search for Azure Data Studio

Find SQL fast in Azure Data Studio

Find fragments of SQL in tables, views, stored procedures, functions, jobs and more

  • Search across multiple object types and multiple databases
  • View object definitions
  • Quickly navigate to objects wherever they happen to be on a server
Download SQL Search

Features

Discover who has database access

Easily find tables, views, stored procedures, functions or parts of SQL within them. Using SQL Search, you can search for the column name and find all the stored procedures where it is used.

Quickly find databases objects in object explorer

Finding anything in the Object Explorer requires a lot of clicking. Using SQL Search, you can jump to the object right from your search results.

View object definitions

Select a table, a view or a stored procedure and view its definition in Transact-SQL source text.

Installing SQL Search for Azure Data Studio

Step 1

Install the SQL Search extension

  1. A - From Azure Data Studio Ctrl/Cmd+Shift+p, type Extensions: Install from VSIX... and hit enter.
  2. B - Navigate to your downloads folder and select the '.vsix' file you just downloaded
  3. C - Click 'install'

Trouble downloading? Retry the download.

Step 2

Install .Net Core 3.1 Runtime

Install .NET Core Runtime on your machine.

Step 3

Start using SQL Search for Azure Data Studio

  1. A - Launch SQL Search using Ctrl/Cmd+Shift+p, then SQL Search.
  2. B - Select the command you want to use

SQL Search commands

Two commands available to you are:

  • SQL Search: Search In Active Connection - use this command to search across all objects using the current active conection.
  • SQL Search: Reindex Active Connection - SQL Search stores results in a cache, use this command to refresh the data.

You can find more information in the extension page within Azure Data Studio.