Redgate Sql Search Ssms 2017

Redgate Sql Search Ssms 2017

Redgate Sql Search Ssms 2017 Rating: 7,5/10 7933 votes

I have SQL server SSMS 17.4 installed. And I tried to install also SQL search 3 from Redgate, but it does not show up on the menu.

-->

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade thes new

For details and more information about what's new in this release, see SSMS release notes.

There are a few known issues with this release.

Previous versions

This article is for the latest version of SSMS only. To download previous versions of SSMS, visit Previous SSMS releases.

Unattended install

You can also install SSMS using a command prompt script.

If you want to install SSMS in the background with no GUI prompts, then follow the steps below.

  1. Launch the command prompt with elevated permissions.

  2. Type the command below in the command prompt.

    Example:

    You can also pass /Passive instead of /Quiet to see the setup UI.

  3. If all goes well, you can see SSMS installed at %systemdrive%SSMStoCommon7IDESsms.exe' based on the example. If something went wrong, you could inspect the error code returned and take a peek at the %TEMP%SSMSSetup for the log file.

Supported SQL offerings (SSMS 18.5)

  • This version of SSMS works with all supported versions of SQL Server 2008 - SQL Server 2019 (15.x) and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.
  • Additionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.
  • SQL Server Integration Services (SSIS) - SSMS version 17.x or later doesn't support connecting to the legacy SQL Server Integration Services service. To connect to an earlier version of the legacy Integration Services, use the version of SSMS aligned with the version of SQL Server. For example, use SSMS 16.x to connect to the legacy SQL Server 2016 Integration Services service. SSMS 17.x and SSMS 16.x can be installed side by side on the same computer. Since the release of SQL Server 2012, the SSIS Catalog database, SSISDB, is the recommended way to store, manage, run, and monitor Integration Services packages. For details, see SSIS Catalog.

Supported operating systems (SSMS 18.5)

This release of SSMS supports the following 64-bit platforms when used with the latest available service pack:

  • Windows 10 (64-bit) *
  • Windows 8.1 (64-bit)
  • Windows Server 2019 (64-bit)
  • Windows Server 2016 (64-bit) *
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)

* Requires version 1607 (10.0.14393) or later

Note

SSMS runs on Windows (AMD or Intel) only. If you need a tool that runs on platforms other than Windows, take a look at Azure Data Studio. Azure Data Studio is a new cross-platform tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Get help for SQL tools

See also

Contribute to SQL documentation

Did you know that you could edit the content yourself? If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.

Complete list of useful and must have add-ins for SQL Server Management Studio - 36 SSMS add-ins

NameDownload pageRelease DateSupport SSMS VersionDeveloperFree versionPrice
SSMSBoostSSMSBoost2019-01-092008-2018Solutions Crew GmbHYes$150
SqlSmashSqlSmash2017-06-102008-2017Smashing Jedis LLCYes$99
SQL Code GuardRed Gate SQL Code Guard2017-07-032016Red GateYesNo
SQL SearchSQL Search2017-02-272008-2017Red GateYesNo
Red Gate SQL TestRed Gate SQL Test2017-03-212008-2017Red GateNo$369
Red Gate SQL Source ControlRed Gate SQL Source Control2017-06-302012-2017Red GateNo$495
SupratimasSupratimas2017-07-112008-2017TTRider LLCYesNo
SSMS Tools PackSSMS Tools Pack2016-11-282012-2017Mladen PrajdićNo€30
SQL Pretty PrinterSQL Pretty Printer2015-11-052008-2014Gudu SoftwareNo$50
SQL Sentry Plan ExplorerSQL Sentry Plan Explorer2017-05-252008-2017SQL SentryYesNo
TSQL Code Smells FinderTSQL Code Smells Finder2013-02-152008-2014Dave ballantyneYesNo
SQLTreeoSQLTreeo2017-06-062012-2017SQLTreeoNo€50
ApexSQL CompleteApexSQL Complete2017-10-262012-2017ApexSQL toolsYesNo
ApexSQL RefactorApexSQL Refactor2017-07-132008-2017ApexSQL toolsYesNo
ApexSQL SearchApexSQL Search2017-06-192008-2017ApexSQL toolsYesNo
ApexSQL Source ControlApexSQL Source Control2017-10-122008-2017ApexSQL toolsNo$299
ApexSQL Unit TestApexSQL Unit Test2017-08-162008-2017ApexSQL toolsYes$499
Spotlight DeveloperSpotlight Developer2016-02-042008-2014Spotlight EssentialsYesNo
dbForge Source ControldbForge Source Control2018-12-212005-2018DevartNo$249
dbForge Unit TestdbForge Unit Test2018-12-212005-2018DevartNo$199
dbForge Data PumpdbForge Data Pump2018-12-212008-2018DevartNo$149
dbForge Index ManagerdbForge Index Manager2018-12-212008-2018DevartNo$99
dbForge SearchdbForge Search2018-12-212008-2018DevartYesNo
dbForge MonitordbForge Monitor2018-12-212008-2018DevartYesNo
dbForge SQL CompletedbForge SQL Complete2018-12-212000-2018DevartYes$149
SoftTree SQL AssistantSoftTree SQL Assistant2016-03-182008-2014SoftTreeNo$179
SQL Enlight For SSMSSQL Enlight For SSMS2016-04-252008-2014UbitSoftNo$195
SQL Hunting DogSQL Hunting Dog2016-03-032008-2014Alex MaslyukovYesNo
Poor Mans T-SQL FormatterPoor Mans T-SQL Formatter2013-10-232008-2012Tao KlerksYesNo
Tabs StudioTabs Studio2017-08-242012-2017Vlasov StudioNo$49
Workload AddinWorkload Addin2017-02-072008-2012Tomáš BauerYesNo
SQL Server DiagnosticsSQL Server Diagnostics2017-06-222016-2017MicrosoftYesNo
VersionSQLVersionSQL2017-02-162012-2017VersionSQLYes$149
Spotlight Tuning PackSpotlight Tuning Pack2018-06-012012-2017Quest Software IncYes$180
Michel Max - SSMS ToolsMichel Max - SSMS Tools2018-11-162012-2018Michel MaxYesNo
SSMS Schema FoldersSSMS Schema Folders2018-10-062012-2018Nicholas RossYesNo

SSMSBoost

Download page: SSMSBoost
Release date: 2019-01-09
Support Version: 2008-2018
Developer: Solutions Crew GmbH
Free version: Yes
Price: $150

Redgate Sql Search Ssms 2017

SSMSBoost add-in adds missing features and improves your productivity when working with Microsoft SQL Server in SQL Server Management Studio.

The main goal of the project is to speed-up daily tasks of SQL DBA and SQL developers and to help you avoid destructive DML executions in production environments.

Licensing options: after 30 day trial period register and get free community license or buy the professional version.

SqlSmash

Download page: SqlSmash
Release date: 2017-06-10
Support Version: 2008-2017
Developer: Smashing Jedis LLC
Free version: Yes
Price: $99

Write maintainable SQL scripts, Understand code better and Navigate faster with SqlSmash, a productivity plugin for SQL Server Management Studio.

  • Search Database Objects
  • Format Sql
  • Execute Current Query
  • Insert Statement Generation
  • Go To Object
  • Increase/Decrease Text Selection
  • Data Protection
  • Find All References
  • Recent Tabs and Queries
  • See Related Data
  • Quick Info
  • Summarize Script
  • Go To Definition

SQL Code Guard

Download link: Red Gate SQL Code Guard
Release date: 2017-02-17
Support Version: 2016
Developer: Red Gate
Free version: Yes
Price: No

SQL Code Guard is a free solution for SQL Server that provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies.

  • Integration with SSMS 2016
  • Integration with Visual Studio 2012/2013
  • Checkin Policy for TFS (how to install & use)
  • Support of msbuild (how to use msbuild)
  • Command line utility (how to use command line utility).
  • API for custom tool development (demo projects can be found in SQL Code Guard folder)

SQL Search

Download page: SQL Search
Release date: 2017-02-27
Support Version: 2008-2017
Developer: Red Gate
Free version: Yes
Price: No

SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

  • 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

Red Gate SQL Test

Download page: Red Gate SQL Test
Release date: 2017-03-21
Support Version: 2008-2017
Developer: Red Gate
Free version: No
Price: $369

Sql

Write unit tests (using the open-source tSQLt framework) for SQL Server databases in SQL Server Management Studio

Red Gate SQL Source Control

Download page: Red Gate SQL Source Control
Release date: 2017-06-30
Support Version: 2012-2017
Developer: Red Gate
Free version: No
Price: $495

Connect your databases to your source control system

  • Version control your schemas and reference data
  • Version control your schemas and reference data
  • Handles referential integrity for you
  • Push and pull Git repos (Synchronize your local and remote Git repositories inside Management Studio)
  • Roll back any changes you don't want
  • Lock objects you're working on
  • Work on a central database or your own local copy
  • Exclude objects with filters
  • Deploy your changes without data loss (Avoid losing data during complex deployments with migration scripts)

Supratimas

Download page: Supratimas
Release date: 2017-07-11
Support Version: 2008-2017
Developer: TTRider LLC
Free version: Yes
Price: No

SQL Server query plan execution visualizer

SSMS Tools Pack

Download page: SSMS Tools Pack
Release date: 2016-11-28
Support Version: 2012-2017
Developer: Mladen Prajdić
Free version: No
Price: €30

  • Keeps your query or window history safe in local files or database
  • Run script at cursor location and an Accidental data destruction protector
  • Keep your favorite statements accessible with a shortcut of your choice
  • Format SQL
  • Color the query windows based on the server/database name or a regex
  • Add custom replacement texts to your scripts in four different features
  • Modifies New Query windows with a template of your choice
  • Run custom scripts from a chosen node in Object Explorer

SQL Pretty Printer

Download page: SQL Pretty Printer
Release date: 2015-11-05
Support Version: 2008-2014
Developer: Gudu Software
Free version: No
Price: No

  • improve SQL readability
  • use a standard style within your organization
  • use automatic formatting eliminates any disagreements
  • embed well formatted and syntax colored SQL into your documents
  • add SQL format feature within 5 minutes
  • quickly convert between SQL and C#, Java, etc.

SQL Sentry Plan Explorer

Download page: SQL Sentry Plan Explorer
Release date: 2017-05-25
Support Version: 2008-2017
Developer: SQL Sentry
Free version: Yes
Price: No

Auto tune presets free. With both a free and PRO version, Plan Explorer builds upon the graphical plan view in SSMS to make query plan optimization more efficient.It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database.

TSQL Code Smells Finder

Download page: TSQL Code Smells Finder
Release date: 2013-02-15
Support Version: 2008-2014
Developer: Dave ballantyne
Free version: Yes
Price: No

TSQL Code can smell, it may work just fine but there can be hidden dangers held within.This is a proof of concept work which will analyze TSQL scripts in an attempt to weed out some of these dangers.

SQLTreeo

Download page: SQLTreeo
Release date: 2017-06-06
Support Version: 2008-2017
Developer: Jakub Dvorak
Free version: No
Price: €50

  • Create custom folders for databases, stored procedures, tables, views and user defined functions
  • Drag&Drop objects in folders
  • Management interface for bulk folder operations
  • Ctrl+click command to alter SQL object
  • Seamless sharing with other team members
  • Bulk folders creation
  • Dynamic folders

ApexSQL Complete

Download page: ApexSQL Complete
Release date: 2017-10-26
Support Version: 2008-2017
Developer: ApexSQL tools
Free version: Yes
Price: No

  • Automatically complete SQL statements
  • Review an objects script and description
  • Improve productivity with snippets
  • Identify the structure of complex SQL queries
  • Keep track of all your tabs
  • Log every executed query
  • Easily navigate to SQL objects
  • Check queries in test mode

ApexSQL Refactor

Download page: ApexSQL Refactor
Release date: 2017-05-08
Support Version: 2008-2017
Developer: ApexSQL tools
Free version: Yes
Price: No

With ApexSQL Refactor you can:

  • Format SQL with over 160 options
  • Qualify objects and expand wildcards
  • Encapsulate SQL into procedures
  • Add surrogate keys
  • Replace one-to-many relationships
  • Change procedure parameters
  • Safely rename SQL objects
  • Locate & highlight unused variables

ApexSQL Search

Download page: ApexSQL Search
Release date: 2017-06-19
Support Version: 2008-2017
Developer: ApexSQL tools
Free version: Yes
Price: No

With ApexSQL Search you can:

  • Search for SQL objects
  • Quickly find data in SQL tables
  • Visualize relationships between objects
  • Edit extended properties
  • Easily navigate to result objects
  • Rename SQL objects safely

ApexSQL Source Control

Download page: ApexSQL Source Control
Release date: 2017-10-12
Support Version: 2008-2017
Developer: ApexSQL tools
Free version: No
Price: $299

  • Integrate SQL source control directly into SSMS
  • Use dedicated or shared development models
  • View conflicts and resolve directly in the UI
  • View a detailed history of changes
  • Lock objects to prevent overwrites
  • Set team policies for check outs and locks
  • Apply changes with dependency aware scripts
  • Create and apply label from source control

ApexSQL Unit Test

Download page: ApexSQL Unit Test
Release date: 2017-08-22
Support Version: 2008-2017
Developer: ApexSQL tools
Free version: No
Price: $499

  • Integrate SQL unit testing directly into SSMS
  • Install and manage tSQLt from multiple sources
  • Create and organize test classes
  • Automate test execution using the CLI
  • Create and organize unit tests
  • Write tests using T-SQL
  • Run tests with a single click
  • Manage all tests with a single form

Spotlight Developer

Download page: Spotlight Developer
Release date: 2016-02-14
Support Version: 2008-2014
Developer: Spotlight Essentials
Free version: Yes
Price: No

Users of SQL Server Management Studio can monitor all their connections via a heatmap, alarms list and realtime diagnostics for FREE.Once installed and configured, users can monitor their connections immediately.The powerful monitoring features communicate important information regarding the status of connections.Severity is color coded so it’s easy to see at a glance what needs your attention.It is easy to connect Spotlight Developer to your Spotlight on SQL Server Diagnostic Server.This makes it possible for you to take advantage of data collections for all your connections in Spotlight on SQL Server.You also get a FREE System health Check, Performance Health Analysis and comprehensive information about your most expensive queries.

dbForge Source Control

Download page: dbForge Source Control
Release date: 2018-12-21
Support Version: 2005-2018
Developer: Devart
Free version: No
Price: $249

dbForge Source Control for SQL Server is a powerful SSMS add-in for managing SQL Server database changes in source control.The tool can link your databases to all popular source control systems, and delivers smooth and clear workflow in a familiar interface.

dbForge Unit Test

Download page: dbForge Unit Test
Release date: 2018-12-21
Support Version: 2005-2018
Developer: Devart
Free version: No
Price: $199

An intuitive and convenient GUI for implementing automated unit testing in SQL Server Management Studio.The tool is based on the open-source tSQLt framework, so SQL developers can now benefit from writing unit tests in regular T-SQL.dbForge Unit Test for SQL Server functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level.

dbForge Data Pump

Download page: dbForge Data Pump
Release date: 2018-12-21
Support Version: 2008-2018
Developer: Devart
Free version: No
Price: $149

dbForge Data Pump is an SSMS add-in for filling SQL databases with external source data and migrating data between systems.The tool supports import and export from 10+ widely used data formats (Text, MS Excel, XML, CSV, JSON etc.) and includes a number of advanced options and templates for recurring scenarios.

dbForge Index Manager

Download page: dbForge Index Manager
Release date: 2018-12-21
Support Version: 2008-2018
Developer: Devart
Free version: No
Price: $99

dbForge Index Manager for SQL Server is a handy SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation.The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance.You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use.dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort.

dbForge Search

Download page: dbForge Search
Release date: 2018-12-21
Support Version: 2008-2018
Developer: Devart
Free version: Yes
Price: No

dbForge Object Search for SQL Server is a FREE add-in for SQL Server Management Studio that allows you to search SQL objects and data in your databases.It can be very difficult to find a required table or to remember names of your stored routines, when a database contains lots of objects.With dbForge Object Search for SQL Server you no longer need to look through the entire SSMS Object Explorer to find a required object.

dbForge Monitor

Download page: dbForge Monitor
Release date: 2018-12-21
Support Version: 2008-2018
Developer: Devart
Free version: Yes
Price: No

  • The Overview tab of the tool allows you to see what actually happens at your SQL Server from various angles.
  • With the IO data tab of the tool, you can easily view statistics of the read and write operations for each database file.
  • The Wait Stats tab, you can identify the resources that slow down the server. It shows the list of waiting tasks encountered by execution threads because resources required for the request fulfillment were busy or not available.
  • dbForge Monitor includes an SQL query performance analyzer that allows you to detect and optimize the most expensive queries that overload the system. Apart from the list of the poorly performing queries, the tool shows the query text and query profiling data that can help you to rewrite a query in the most productive way.

dbForge SQL Complete

Download page: dbForge SQL Complete
Release date: 2018-12-21
Support Version: 2000-2018
Developer: Devart
Free version: Yes
Price: $149

dbForge SQL Complete provides a wide range of code completion features that relieve users from remembering long and complex object names,column names, SQL operators, etc., but instead allows concentrating on writing high-quality SQL code with proper formatting that is easy to understand and interpret.

SoftTree SQL Assistant

Download page: SoftTree SQL Assistant
Release date: 2016-03-18
Support Version: 2008-2014
Developer: SoftTree
Free version: No
Price: $179

SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

SQL Enlight for SSMS

Download page: SQL Enlight for SSMS
Release date: 2016-04-25
Support Version: 2008-2014
Developer: UbitSoft
Free version: No
Price: $195

  • Advanced static analysis
  • T-SQL code formatting
  • Statements history
  • Validate T-SQL code for syntax errors
  • Script Summary
  • Refactoring
  • Continuous integration support

SQL Hunting Dog

Download page: SQL Hunting Dog
Release date: 2016-03-03
Support Version: 2008-2014
Developer: Alex Maslyukov
Free version: Yes
Price: No

  • Quickly find tables, stored procedure, functions and views
  • Completely removes the pain of clunky Object Explorer
  • Switch between different servers and databases
  • Perform common operation (select data, modify table, design table, etc.) with ease

Poor Mans T-SQL Formatter

Download page: Poor Mans T-SQL Formatter
Release date: 2013-10-23
Support Version: 2008-2012
Developer: Tao Klerks
Free version: Yes
Price: No

This formatter does implement a high-level SQL tokenizer and parser, but the granularity of the parser is not very high.It does not distinguish between different types of DML, it does not parse full expression trees, etc - there's a lot it doesn't do, it just does the bare minimum to support the target formatting.

Tabs Studio

Download page: Tabs Studio
Release date: 2017-08-24
Support Version: 2012-2017
Developer: Vlasov Studio
Free version: No
Price: $49

Tabs Studio is a Visual Studio and SSMS extension empowering you to work comfortably with any number of open documents.

  • Multiple rows of tabs
  • Tab grouping
  • Tab coloring
  • Title transformation
  • Keyboard navigation
  • Flexible behavior
  • Customizable presentation
  • Extensibility API

Workload Addin

Download page: Workload Addin
Release date: 2017-02-07
Support Version: 2008-2012
Developer: Tomáš Bauer
Free version: Yes
Price: No

There are tools in SQL Server that allow to collect SQL statements for a certain period.The problem of these tools is that the amount of data recorded in this way may not be small and that the recorded data requires further processing.Also, work with these tools may not be easy.This article describes a tool that solves the problem described above.This tool can automatically collect information about executed SQL statements and it does their analysis and stores the required information in a custom SQL database, avoiding unnecessary or duplicate SQL statements being stored.

SQL Server Diagnostics

Download page: SQL Server Diagnostics
Release date: 2017-06-22
Support Version: 2016-2017
Developer: Microsoft
Free version: Yes
Price: No

SQL Server Diagnostics is a collection of micro-services which enables SQL Server customers to self-help and debug SQL Server issues related to memory dumps and receive recommended fixes for their issues.

VersionSQL

Download page: VersionSQL
Release date: 2017-02-16
Support Version: 2012-2017
Developer: VersionSQL
Free version: Yes
Price: $149

Lightweight add-in to connect your databases to your source control system

Spotlight Tuning Pack

Download page: Spotlight Tuning Pack
Release date: 2018-06-01
Support Version: 2012-2017
Developer: Quest Software Inc
Free version: Yes
Price: $180

Powerful SQL optimization and query plan analysis.The analysis will indicate whether the Query Plan can be tuned to improve performance, or whether the SQL Statement can be rewritten to optimize its efficiency.

Michel Max - SSMS Tools

Download page: Michel Max - SSMS Tools
Release date: 2018-11-16
Support Version: 2012-2018
Developer: Michel Max
Free version: Yes
Price: No

  • Format SQL Code.
  • Prepare the Procedures/Functions to be called.
  • Regions to organize the code.
  • Retrieve the complete Information of a Table.
  • Tab Colorize, base in the configuration window you can colorize the existing session based in the filters that you applied, making easy to the developer to identify each server/database he/she is working on.
  • Selection Highlight for the same word in the SQL Code.
  • Style Markers for the same word in the SQL Code.
  • Configurable CRUD creation.
  • Copy/Paste Table Structure and Data (Client Side).
  • Grid Search, with advanced Extended and Regular Expression.
  • Grid Search Highlight.
  • Grid Style Markers.
  • Grid Export to JSON, Excel XML.
  • Grid Image Capture.
  • Configurable Header Text Template, with quick insert, so you can easily sign you codes.
  • Quick encapsulate code in region.

Other versions:

SSMS Schema Folders

Rimworld cotton fiber to cloth. Download page: SSMS Schema Folders
Release date: 2018-10-06
Support Version: 2012-2018
Developer: Michel Max
Free version: Yes
Price: No

This an extension for SQL Server Management Studio 2012, 2014, 2016 and 17.It groups sql objects in Object Explorer (tables, views, etc.) into schema folders.

Redgate Sql Search Ssms 2017
© 2020