FREETEXTTABLE Alternative

问题:

We're looking to move a database from a local SQL 2008 server to SQL Azure however we use FREETEXTSEARCH which is currently unsupported. Is there an alternative to FREETEXTSEARCH that we could use that is supported on AZURE, and/or can you write a custom function that does the same thing?

回答1:

I would take a look at Lucene.Net. It is great free text search engine. There is a Azure version available. It powers the search on StackExchange network. Lucene on Azure.

回答2:

You can use FULLTEXT search Azure SQL just doesn't provide you an interface to create full indexes, you'll have to create them via script.