If you need to find database objects (e.g. Tables, columns, and triggers) by name - have a look at the free Redgate Software tool called SQL Search which does this - it searches your entire database for any kind of string(s).
- If you need to find database objects (e.g. Tables, columns, and triggers) by name - have a look at the free Redgate Software tool called SQL Search which does this - it searches your entire database for any kind of string (s).
- Download free SQL Server tools from Redgate to help you search your databases, manage scripts and more.
- Contact support. For product-related issues, please Submit a request. For any security issues, please report them via this page. US & Canada (toll free): 1 866 627 8107 UK (free phone): 0800 169 7433 Rest of the World: +44 (0)1223 437 901.
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. | |||
Speed up SQL Server database development by finding SQL objects fast in Visual Studio.
Redgate SQL Search is a free extension for Visual Studio to quickly search for fragments of SQL across databases, and easily navigate to those objects. This saves time and makes teams more productive, so you can get back to the task in hand.
Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
Quickly navigate to objects wherever they happen to be on a server
Search across multiple object types and multiple databases
Find all references to an object
Search with booleans and wildcards
Work in either Visual Studio or SQL Server Management Studio
Redgate Search Tool Software
“SQL Search saves time and money for people and organizations! It’s an easy to use and efficient tool, allowing you to concentrate on more interesting and challenging things.” - Dmitry Televca, Senior Software Engineer, Aculocity.
For more information, visit the Redgate website or SQL Search documentation.
Did you know Redgate has more extensions for Visual Studio to help you extend DevOps processes to SQL Server databases? Check out:
Redgate Search Toolbar
- SQL Change Automation for VS2017 and VS2019 or SQL Change Automation for VS2015 – develop, source control, and safely automate deployments of database changes alongside application changes.
- Redgate SQL Prompt Pro – improve productivity with advanced IntelliSense-style code completion to further ensure database development won’t be a bottleneck to delivering value quickly.