Are thesauruses supported in Azure SQL for full text search

MATTHEW C JOHNSON 1 Reputation point
2021-11-22T15:01:23.787+00:00

Found this from several years ago: https://azure.microsoft.com/en-us/blog/full-text-search-is-now-available-for-preview-in-azure-sql-database/ Is this still the case? Is the use of thesauruses for full text search still not supported in Azure sql? Any plans to make it supported?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2021-11-22T17:26:44.257+00:00

    The thesaurus feature of Full-Text Search is not supported on Azure SQL Database since the feature involves access to the file system and changes registry settings and files, and that is not allowed on Azure SQL Database. That is the answer I have received from Azure SQL Database managers in the past.

    You may need to create an Azure VM with SQL Server installed to make use of the Thesaurus feature on Azure.

    Please visit this forum thread for more information.