A hello-world example of the Azure SQL Database full-text search capability.
- SQL Server 2019 Developer Edition - Database Engine only with optional Full-Text Search components; do not install the standalone SQL Server Data Tools (SSDT) component here.
- SQL Server Management Studio (SSMS) 18.x
- Visual Studio 2022 Community Edition with SQL Server Data Tools workload turned on (see license terms regarding allowed use for SSDT in orgs).
- Azure SQL Database
This full-text search demonstration shows you how to:
- setup a SQL Server Database project
- use post-deployment scripts to load data with an idempotent technique
- create a full-text catalog and index on an indexed view
- fuzzy search the catalog to return matching records with relevance ranking
- setup and use SQL deployment configuration settings
- build and deploy a database using DACPAC-based publishing (see build and release pipelines on Azure DevOps)
- install the tools listed below
- open learnDB.sln in Visual Studio Community
- edit the "database.csproj" properties from the Solution Explorer right-click menu; change the Debug deploy target to your local instance of SQL Server
- click the "start" button to deploy (monitory the Output window for success/failure) -- this will take several minutes due to a large amount of post-deploy data loading
- open a new query window in SSMS and execute
EXEC dbo.usp_DictionarySearch @searchterm='beer brewing'
to get example search results