locked
SQL Azure - Free Text Search query RRS feed

  • Question

  • Apologies if this has been asked a 1000 times before. I'm interested to know how (or indeed if) people are working around the lack of FTS support in the current Azure environment. I have sprocs that use FREETEXTTABLE and CONTAINSTABLE which is currently a showstopper for me.
    Monday, January 4, 2010 9:00 PM

Answers

  • Unfortunately full text search is not supported at this time. We may add this feature in a future release. But apparently, a search of "full text" on http://www.mygreatwindowsazureidea.com/pages/34685-sql-azure-feature-voting does not reveal any results. You can submit a new feature request on this site, and more people voting for the feature means more likely it will be in the next version.
    Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yi-Lun Luo Monday, January 11, 2010 10:20 AM
    Tuesday, January 5, 2010 9:18 AM

All replies

  • Unfortunately full text search is not supported at this time. We may add this feature in a future release. But apparently, a search of "full text" on http://www.mygreatwindowsazureidea.com/pages/34685-sql-azure-feature-voting does not reveal any results. You can submit a new feature request on this site, and more people voting for the feature means more likely it will be in the next version.
    Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yi-Lun Luo Monday, January 11, 2010 10:20 AM
    Tuesday, January 5, 2010 9:18 AM
  • Yi-Lun

    According to the SQL Azure Feature Voting <small>Forum</small> at:

    http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting

    you will see that there are 376 votes for FREETEXT - 3rd position in Must-Have's.

    Can you please give deadlines as to when this feature will be in SQL Azure?

    Tuesday, July 27, 2010 3:59 PM
  • Over a year later and still nothing.

    FREETEXTTABLE not yet supported. We will wait much longer?

    See you soon.

    Wednesday, April 13, 2011 3:16 PM
  • Another year passes, and still no FREETEXT in SQL Azure.

    Microsoft rang us to ask why we are not using SQL Azure, and we told them that lack of FREE TEXT searching is a showstopper for companies who rely upon this with their on-premise SQL Server installations.

    SQL Azure must have the SAME SET OF FEATURES as on-premise SQL Server otherwise it will not gain enough traction in the competitive 'database as a service' market.

     


    TriSys Business Software
    Tuesday, November 1, 2011 9:12 AM
  • An update would be appreciated.
    Wednesday, December 12, 2012 4:01 AM
  • Another year has passed and still no FREETEXT in SQL Azure.

    SQL Azure must have the SAME SET OF FEATURES as on-premise SQL Server otherwise it will not gain enough traction in the competitive 'database as a service' market. Both Amazon RDS and Oracle are now in this game and both offer FREETEXT searching.


    TriSys Business Software

    Thursday, February 7, 2013 10:01 AM
  • Hi,

    I think Free Text searching is supported if you create a Windows Azure Virtual Machine with SQL Server installed on it. That will provide the full SQL Server feature support.

    Regards,

    Alan


    Free e-book: Windows Azure Service Bus Developer Guide.

    Thursday, February 7, 2013 10:08 AM
  • FTS is now in preview in SQL DB V12
    Thursday, September 10, 2015 7:34 PM
  • It is in preview now.
    Thursday, September 10, 2015 7:35 PM