How to perform Full Text Search on SQL Azure

0 votes
I have a database that I am migrating to SQL Azure. There are a couple of stored procedures in this database that rely on ContainsTable. From my understanding, SQL Azure does not support this. Because of this, I was hoping there would be a way to imitate this functionality in C# code.

Does anyone know how to either: a) Utilize ContainsTable in SQL Azure or b) Imitate it in C# code?
Sep 25, 2018 in Azure by cloudie_crank
• 1,610 points
1,688 views

1 answer to this question.

0 votes

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.

Also,

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/

answered Sep 25, 2018 by null_void
• 3,220 points

Related Questions In Azure

0 votes
1 answer

How to upload a file on to Azure Blob storage without writing a code?

You can find the below tools useful ...READ MORE

answered Apr 13, 2018 in Azure by club_seesharp
• 3,450 points
1,546 views
0 votes
1 answer

How to identify a deadlock in SQL Azure?

Monitoring of SQL Azure is more limited ...READ MORE

answered Jun 19, 2018 in Azure by club_seesharp
• 3,450 points
2,564 views
0 votes
2 answers

How to restore SQL Server .bak file to Azure SQL Database?

To restore SQL Server .bak file you ...READ MORE

answered May 28, 2019 in Azure by sherry
• 140 points
33,516 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 9, 2018 in Azure by club_seesharp
• 3,450 points
6,710 views
0 votes
1 answer

How to configure kubectl command to access remote kubernetes cluster on azure?

Found a way to access remote kubernetes ...READ MORE

answered Aug 11, 2018 in Azure by club_seesharp
• 3,450 points
9,904 views
0 votes
1 answer

How to perform dependency injection using Azure WebJobs SDK?

Azure WebJobs SDK now supports instance methods. ...READ MORE

answered Aug 23, 2018 in Azure by club_seesharp
• 3,450 points
2,320 views
0 votes
2 answers

How to deploy a simple static micro site on Microsoft Azure?

Create an Azure Storage account ("hot file" ...READ MORE

answered Jun 4, 2020 in Azure by René
1,340 views
0 votes
1 answer

How to import Azure SQL backup (.bacpac) to LocalDB using Visual Studio?

If you have this folder on your ...READ MORE

answered Sep 24, 2018 in Azure by null_void
• 3,220 points
2,372 views
+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
2,564 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
1,139 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP