SQL Toolbelt Essentials $1,985 Ten essential SQL Server tools for releases and productivity. | SQL Toolbelt 13 SQL Server tools to cover automation and monitoring | ||
---|---|---|---|
SQL Compare Pro | '> | ||
SQL Compare is the industry standard for comparing and releasing SQL Server database schemas quickly and accurately. 71% of the Fortune 100 use SQL Compare to compare SQL Server databases – because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time. How to compare and synchronize SQL Server schemas with SQL Compare (2:47) | |||
SQL Data Compare Pro | '> | ||
SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents. You can work with live databases, backups, or SQL scripts in source control. Damaged or missing data can be restored to a single row, without the need for a full database recovery. | |||
SQL Source Control | '> | ||
Version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. And because it works with the tools you already use, it's an easy setup. An intro to SQL Source Control with SQL Server MVP Steve Jones | |||
SQL Prompt | '> | ||
An add-in for SQL Server Management Studio and Visual Studio, SQL Prompt strips away the repetition of coding. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works. SQL Prompt - a short introduction (4:14) | |||
SQL Data Generator | '> | ||
SQL Data Generator is a fast, simple tool for generating realistic test data. It can instantly provide generators based on table and column names, field length, data types, and other existing constraints. They can be customized to meet your requirements. | |||
SQL Doc | '> | ||
Document your databases automatically. Create documents as HTML, PDF, Microsoft Word, or Compiled HTML Help files. | |||
SQL Test | '> | ||
If you want to do SQL Server unit testing in T-SQL, and run it as part of your automated builds, SQL Test is the place to start. It's simple to set up, you don't need extra tools, and you don't need to learn new technologies. | |||
SQL Multi Script | '> | ||
Run multiple scripts on multiple servers with just one click SQL Multi Script lets you execute multiple scripts against multiple SQL Servers quickly and easily | |||
SQL Dependency Tracker | '> | ||
Visualize complex databases simply Dynamically explore and document all your database object dependencies | |||
SQL Change Automation | '> | ||
Continuous integration and release automation for your SQL Server database SQL Change Automation extends your application development processes so you can automate your database delivery too. You get instant feedback on your code changes, get the exact script you need for release automation and, when you’re ready, you can release to production in confidence. | |||
SQL Monitor | '> | ||
Save 2 hours each day monitoring your SQL Servers SQL Monitor is a SQL server monitoring tool that transforms the way you look at your database. It cuts your daily check to minutes, with a web-based overview of all your SQL Servers. | |||
SQL Backup Pro | '> | ||
Compress, verify, and encrypt SQL Server backups Fully verified SQL Server backups you can rely on | |||
SQL Search | '> | ||
SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases. |
Published 10 October 2017
Download free SQL Server tools from Redgate to help you search your databases, manage scripts and more. Browse a full list of Redgate's tools for SQL Server, Oracle,.NET, and MySQL. Popular free Alternatives to Red Gate Sql Compare for Windows, Software as a Service (SaaS), Mac, Linux, Web and more. Explore 5 apps like Red Gate Sql Compare, all suggested and ranked by the AlternativeTo user community.
- Redgate ® SQL Search 3.4.1. Comparison was conducted on January 28, 2020. Super useful SQL tool: ApexSQL Search. I wish I had met you before!
- Sometimes, after upgrading SQL Search (or a bundle of products that contains SQL Search), SQL Search will disappear from the Redgate toolbar in SQL Server Management Studio. This can sometimes be fixed by repairing the SIP Framework installation: Open Programs and Features. Right-click SSMS Integration Pack Framework 1 and select Repair.
This page explains how to search for objects using SQL Search, how to narrow the scope of a search, and what search syntax is supported.
Opening SQL Search
SQL Server Management Studio
To open SQL Search in Management Studio, click SQL Search in the Redgate toolbar:
If you can't see the Redgate toolbar, enable it by right-clicking in the toolbar area and clicking Redgate.
Alternatively, open SQL Search with Ctrl+Alt+D.
Visual Studio
In Visual Studio, SQL Search can be found in the Tools menu.
How to search
To search, type in the search bar:
Contents:
Search results appear when you've typed two or more characters. The results update as you type.
The first 500 results are shown for each database. If there are more than 500 results, a banner is shown at the bottom of the search results panel:
To see the rest of the results, click Show all.
Redgate Search Tool Software
Searching for an exact word or phrase
By default, SQL Search returns objects that contain the search terms you typed anywhere in the object. To search for an exact word or phrase, select Match whole words only.
When using match whole words only, it won't match parts of words or phrases. For example, searching for 'user' won’t return 'username', and searching for 'myTable' won't return '[myTable]'.
Changing the search scope
You can search specific servers, databases, or object types. Select these on the drop-down menus to the right of the search bar:
Wildcards
You can use the following wildcards in a search:
Asterisk (*) wildcard
You can use * as a wildcard to match 0 or more characters, similar to a SQL LIKE clause.
For example, search for 'b*' to find all objects containing words beginning with b.
Question mark (?) wildcard
The ? wildcard to matches exactly one character.
For example, search for 'b?' to find all objects containing words of two characters beginning with b.
List ([]) wildcard
This [] wildcard matches one character from a list of characters.
![Redgate Search Tool Redgate Search Tool](/uploads/1/1/8/2/118268164/226867241.png)
For example, search for '[xyz] ' to find all objects containing any single x, y, or z character.
This wildcard also allows a range of characters. For example, search for '[a-z]' to match any single character from a to z.
Caret (^) wildcard
You can use ^ as a wildcard at the beginning of a list to match any character except any character in the list.
For example, search for '[^0-9]' to match any single character except a numeric character.
Escaping wildcards
Redgate Search Tool Download
If you want to search for a wildcard as a literal character, you can escape the wildcard character by wrapping it in square brackets.
For example, searching for '[*]' will search for anything containing an asterisk.
Please note that this does not work with square brackets themselves.
Search limitations
Object Type Limitations
When searching in 'Other' object types, SQL Search doesn't find some object types, including roles, certificates, and full-text catalogs.
This is because it only indexes objects in the following Object Catalog Views:
- sys.objects
- sys.sql_modules
- sys.check_constraints
- sys.default_constraints
- sys.computed_columns
Any object types that aren't in these views won't be found by SQL Search.
Square Brackets
Square brackets around identifiers are filtered out of the index we create to provide fast searches, so you can't match on them even if you are using wildcard matching and escape them.
Didn't find what you were looking for?