I've been in the process of migrating our website from our current hosting provider over to Microsoft Azure. One of the issues that I ran into when migrating some of our older sites has to do with Full Text Indexes. When trying to use the SSMS migration tool, I received an error message stating that Full Text Indexes are not supported.

Some Googling quickly found this link:

https://azure.microsoft.com/en-us/blog/full-text-search-is-now-available-for-preview-in-azure-sql-database/

To perform the migration, I first deleted the indexes on the current database:

DROP FULLTEXT INDEX ON table_name

I then ran the migration tool to migrate the database over to SQL Azure. After configuring the users and permissions, I then recreated the catalog and index:

CREATE FULLTEXT CATALOG Search AS DEFAULT;

CREATE FULLTEXT INDEX ON dbo.table_name(column1,column2) KEY INDEX primary_key ON Search; 

ALTER FULLTEXT INDEX ON dbo.table_name ENABLE;

ALTER FULLTEXT INDEX ON dbo.table_name START FULL POPULATION;