Search code examples
sqlazureinstancemanagedazure-cognitive-search

Connect Azure Search to Managed Instance SQL

Hello I am looking information on how to connect Azure Search Service to Managed Instance SQL on Azure

In other words

using the following for Managed instance in my indexer should work fine there is no difference btw implementing this for Azure SQL database and Azure SQL MI ? 

    "name" : "myazuresqldatasource", 
    "type" : "azuresql", 
    "credentials" : { 
    "connectionString" : "Server=tcp:<your server>.database.windows.net,1433;Database=<your database>;User ID=<your user name>;Password=<your password>;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" }, 
"container" : { "name" : "name of the table" } –
Solution

  • You can connect your search service to managed SQL database by going through import data flow in Azure Portal:

    enter image description here

    Then in Data source section select Azure SQL Database and there you can either select existing (managed) database or choose to input connection string. You should do the latter.