Menu
Does SQL Azure supports Full-Text catalogs and indexes?
796
Full-Text Search is available in Premium, Standard and Basic service tiers in Azure SQL Database V12. You can start using it immediately on your databases as there is no other service configuration necessary.
To create a full text index choose your table and right click on that table and select “Define Full-Text Index” option. Now select Unique Index. It is compulsory that for “Full Text Index” table must have at least one unique index. Select columns name and language types for columns.
Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on the rules of a particular language such as English or Japanese. Full-text queries can include simple words and phrases or multiple forms of a word or phrase.
SQL Azure Database does not currently (January 2014) support Full Text Search. Many requiring this functionality have opted to use Lucene.NET instead. There's a useful overview of Lucene.NET plus code samples below:
Lucene.NET Overview and Code Samples
EDIT - October 2015:
Full-Text Search is now available in Azure SQL Database (GA)
122
As of August 2014, Microsoft is offering a Search-as-a-Service named Azure Search:
Azure Search is a search-as-a-service solution that allows developers and cloud architects to embed a sophisticated search experience into web and mobile applications without having to worry about the complexities of full-text search and without having to deploy, maintain, or manage any infrastructure.
With Azure Search, a developer can enable the power of searching data in their application, reduce the complexity around managing and tuning a search index, and get up and running quickly using familiar interfaces and a consistent platform.
See http://azure.microsoft.com/en-us/services/search
Update:
As of April 30, 2015 - Full Text Search is available in Preview for SQL Azure. See http://azure.microsoft.com/blog/2015/04/30/full-text-search-is-now-available-for-preview-in-azure-sql-database/
43
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
