I recently upgraded to SSMS 2016 and the Redgate tools I have for 2014 are still there but missing in 2016. Do i need to uninstall and reinstall Redgate? If so do i need to deactivate my key before. Manage your account settings for your Redgate products, support, emails, the forums, and Simple Talk.
SQL Toolbelt Essentials $1,985 Ten essential SQL Server tools | SQL Toolbelt 13 SQL Server tools | ||
|---|---|---|---|
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
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.
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.
For example, search for '[xyz] ' to find all objects containing any single x, y, or z character.
Redgate Search Tools
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
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
Redgate Sql Search Tool
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.
Redgate Sql Search Toolbar
Didn't find what you were looking for?