SQL Azure and Full-Text Catalogs, Indexes and Searching

azure azure-sql-database
Coppermill picture Coppermill · Apr 28, 2013 · Viewed 8.6k times · Source

Does SQL Azure supports Full-Text catalogs and indexes?

Answer

QFDev picture QFDev · Apr 28, 2013

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)

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
Azure SQL Database "DTU percentage" metric

With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether to upgrade or downgrade to another tier. When reading Azure SQL Database Service Tiers and Performance Levels, it only talks …

Read More
How to re-create database for Entity Framework?

I have got into a bad state with my ASP.Net MVC 5 project, using Code-First Entity Framework. I don't care about losing data, I just want to be able to start fresh, recreate the database and start using Code-First migrations. …

Read More