locked
SQL Azure - FullText Indexes RRS feed

  • Question

  • Hi,

    I read that SQL Azure wouldn't support FullText Indexes in it's initial release, but that was in a post back from 2009. I was wondering if SQL Azure now supports FullText indexes, it's the only thing preventing us form porting across our infrastructure to Azure.

    If the answer is no, then are there any plans to implement this? Do Microsoft have a publicly available list of planned features and when they would be implemented by?

    Many Thanks,
    Ady 


    Tuesday, September 6, 2011 5:26 AM

Answers

  • Adrian,

    what i do know is that a lot of people want fulltext indexes but as far as i know it's not there (yet).

    The roadmap for Microsoft's cloud offerings is not really available since they need to be flexible and change plans when they want to. Since it's cloud you can innovate constantly.

    regards,

    Riccardo

    • Marked as answer by KJian_ Thursday, September 15, 2011 4:43 AM
    Tuesday, September 6, 2011 8:01 AM
  • Hi Adrian,

    You can vote for this feature at mygreatwindowsazureideas.com. As you can see it's second in line ;-).

     


    With regards,

    Patriek

    www.patriekvandorp.net
    If this reply is of help to you, please don't forget to mark it as an answer.
    • Marked as answer by KJian_ Thursday, September 15, 2011 4:44 AM
    Tuesday, September 6, 2011 8:57 AM
  • Although SQL Azure is not supporting Full-Text-Index, there's actually an alternative to do full-text-index using Lucene.NET with Blob Storage http://code.msdn.microsoft.com/AzureDirectory
    regards, wely
    • Proposed as answer by K.Mohamed Faizal Monday, September 12, 2011 3:33 AM
    • Marked as answer by KJian_ Thursday, September 15, 2011 4:44 AM
    Wednesday, September 7, 2011 1:48 AM

All replies

  • Adrian,

    what i do know is that a lot of people want fulltext indexes but as far as i know it's not there (yet).

    The roadmap for Microsoft's cloud offerings is not really available since they need to be flexible and change plans when they want to. Since it's cloud you can innovate constantly.

    regards,

    Riccardo

    • Marked as answer by KJian_ Thursday, September 15, 2011 4:43 AM
    Tuesday, September 6, 2011 8:01 AM
  • Hi Adrian,

    You can vote for this feature at mygreatwindowsazureideas.com. As you can see it's second in line ;-).

     


    With regards,

    Patriek

    www.patriekvandorp.net
    If this reply is of help to you, please don't forget to mark it as an answer.
    • Marked as answer by KJian_ Thursday, September 15, 2011 4:44 AM
    Tuesday, September 6, 2011 8:57 AM
  • Here is the MSDN article on unsupported T-SQL statements: http://msdn.microsoft.com/en-us/library/ee336253.aspx

     

    Tuesday, September 6, 2011 2:26 PM
  • Although SQL Azure is not supporting Full-Text-Index, there's actually an alternative to do full-text-index using Lucene.NET with Blob Storage http://code.msdn.microsoft.com/AzureDirectory
    regards, wely
    • Proposed as answer by K.Mohamed Faizal Monday, September 12, 2011 3:33 AM
    • Marked as answer by KJian_ Thursday, September 15, 2011 4:44 AM
    Wednesday, September 7, 2011 1:48 AM
  • Just saw this post, and unfortunately it is not supported yet

    Here is the list of unsupported commands

    http://msdn.microsoft.com/en-us/library/windowsazure/ee336253.aspx


    Please mark this as answer if it helps.
    Microsoft Certified Trainer
    Microsoft Certified Professional Developer
    Blog: http://www.EnterpriseApplicationsDevelopment.com/

    Friday, April 12, 2013 6:58 PM
  • Hi Adrian,

    I am part of the Microsoft product group within the SQL organization.  It would be great to better understand your scenario and needs in this area (and anyone else on this thread who is interested in this feature). Would you be up for a brief chat? My email is Liam.Cavanagh <at> Microsoft<dot>com

    Liam


    Sr. Program Manager, SQL Azure Strategy - Blog

    Tuesday, April 16, 2013 12:01 AM
  • It's been a while but in my case we are using a third party CMS product that we want to host databases for in Azure. At first for distributed development but later there is a production application.  Unfortunately, the database includes fulltext and so we can't load it. We will have to make other plans that don't include this option. Fortunately there are plenty of cloud options that do support it.

    Friday, February 7, 2014 5:41 PM
  • >> You can vote for this feature at mygreatwindowsazureideas.com. As you can see it's second in line ;-). Voted and where is result? 5 years aged feature ....
    Friday, July 4, 2014 11:41 AM