Is there a SQL Search API for VS2017.

I need to search if a certain "SearchString" is present or being used in any database(s).  It can be in a Stored Procedure, Table Name, Table Column Name, Stored Procedure references, Views, Synonyms, or any type of SQL Objects.

Thanks for any help you can give me.
Tagged:

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi, thank you for your forum post.

    There is no API for SQL Search.

    However, SQL Search is available to use within VS2017.

    You need to install SQL Server Data Tools (SSDT) which is not installed by default.  In order to use SQL Search within VS2017, you need to run the Visual Studio installer and select the Data Storage and Processing workload which includes the SSDT components.

    Many Thank
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.