What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    Eddie DEddie D Posts: 1,792 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.