Is there a SQL Search API for VS2017.

NewToRedGateNewToRedGate Posts: 1 New member
in SQL Search
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:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,803 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
    · Share on Twitter
Sign In or Register to comment.