March 19, 2009 at 12:55 pm
Hi
We have a table that has a full text index on a bunch of ntext columns that are on it. For our next release we are trying to change those columns to nvarchar(max). We have a third party tool that generates our upgrade scripts. The script it generated basically drops the full text index, creates a new temp table, copies the records into the temp table, deletes the old table, renames the temp table and creates the full text index.
The only problem is that after this change all full text searches on the table return no results. Every record has a rank of 0 where previously the ranking was over 500.
Any idea what the problem could be or a different way to go about doing the upgrade?
Thanks
March 19, 2009 at 7:34 pm
I don't think a tool is supposed to do that for you because you need to manually drop all your 2000 Full Text indexes and move the database to 2005 then ALTER the Tables and change NText to Nvarchar (Max) and then define new Full Text indexes to auto populate. You can create new indexes by right click on your tables in 2005.
You have to manually do this because you are moving from a different Full Text engine to native Full Text engine and remember to turn on the service in configuration manager.
Post again if you still need help.
Kind regards,
Gift Peddie
March 19, 2009 at 7:43 pm
Hi
Thank you for the response.
We are just modifying a table in 2005 database that has ntext columns that we are trying to change to nvarchar(max).
March 19, 2009 at 7:47 pm
Then drop the existing Full Text index then ALTER the table to change NText to NVarchar(max) and then redefine the index Full Text to auto populate. I still think this is manual task not for a tool.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply