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:
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;