all groups > sql server full text search > march 2006 >
You're in the

sql server full text search

group:

Steps to migrate FTS SQL 2000 to SQL 2005 side by side


Steps to migrate FTS SQL 2000 to SQL 2005 side by side Pineda
3/28/2006 8:30:03 AM
sql server full text search:
Hi,
I am trying to upgrade side by side SQL 2000 to SQL 2005, one database
with FTS catalogs. I want always to have the SQL 2000 production server
online.
I have tried in one test environment to detach the SQL 2000 DB , but this
not work because when I tried to reattached the DB on SQL 2000 , I must to
set enable the full text property and then, the catalogs are rebuild ( not
valid solution) .
I cannot aply the KB article 240867, because this is valid only when move
or copy FTS catalogos between SQL with the same version.

Anyone does know the correct steps to do this?

Thanks.

Re: Steps to migrate FTS SQL 2000 to SQL 2005 side by side renedevries NO[at]SPAM gmail.com
4/12/2006 1:44:08 PM
I am just going through the same migration. The FTI on 2005 needs to be
rebuild. Lucky, we found that building the index was 8 times faster
(from 54 hours to 6 hours).

Ren=E9


[quoted text, click to view]
AddThis Social Bookmark Button