What is the easiest way to migrate full text indexes from SQL2K to SQL2K5?
You can't. SQL 2005 uses a different format. You need to rebuild them completely. "Ravi Lobo" wrote in message news:171F5C37-88AF-4651-9BED-922A9DC384B7@microsoft.com... > What is the easiest way to migrate full text indexes from SQL2K to SQL2K5?
Thank you, Hilary! I undertsand when you say - REBUILD, you meant - RECREATE. "Hilary Cotter" wrote: > You can't. SQL 2005 uses a different format. You need to rebuild them > completely. > "Ravi Lobo" wrote in message > news:171F5C37-88AF-4651-9BED-922A9DC384B7@microsoft.com... > > What is the easiest way to migrate full text indexes from SQL2K to SQL2K5? > > >
IIRC they will both do the same thing! "Ravi Lobo" wrote in message news:D6590E40-7080-4E8C-B828-E08D25713761@microsoft.com... > Thank you, Hilary! > I undertsand when you say - REBUILD, you meant - RECREATE. > > "Hilary Cotter" wrote: > >> You can't. SQL 2005 uses a different format. You need to rebuild them >> completely. >> "Ravi Lobo" wrote in message >> news:171F5C37-88AF-4651-9BED-922A9DC384B7@microsoft.com... >> > What is the easiest way to migrate full text indexes from SQL2K to >> > SQL2K5? >> >> >>
Thank you, again! "Hilary Cotter" wrote: > IIRC they will both do the same thing! > > "Ravi Lobo" wrote in message > news:D6590E40-7080-4E8C-B828-E08D25713761@microsoft.com... > > Thank you, Hilary! > > I undertsand when you say - REBUILD, you meant - RECREATE. > > > > "Hilary Cotter" wrote: > > > >> You can't. SQL 2005 uses a different format. You need to rebuild them > >> completely. > >> "Ravi Lobo" wrote in message > >> news:171F5C37-88AF-4651-9BED-922A9DC384B7@microsoft.com... > >> > What is the easiest way to migrate full text indexes from SQL2K to > >> > SQL2K5? > >> > >> > >> > > >
"Hilary Cotter" wrote: > You can't. SQL 2005 uses a different format. You need to rebuild them > completely. This is an interesting question as I am facing a similar issue at present. I have a bunch of Version80 databases with full text catalogs on SQL Server 2000 servers that are going to be moved to a SQL Server 2005 cluster. The intention is to keep them as Version80 databases (for the most part) and the intention was to carry the full text catalog across to save rebuilding them. However it seems that even though the database remains as Version80 I need to rebuild the catalog anyway. Is that what you think? It seems to be the case from my testing though I have to say that my understanding of full text indexing is less than complete.
Yes, that is correct, you will need to rebuild them. "Mark Harrison" <Mark Harrison@discussions.microsoft.com> wrote in message news:5A00F582-7CFE-4912-BAAC-D1A421FD9319@microsoft.com... > "Hilary Cotter" wrote: > >> You can't. SQL 2005 uses a different format. You need to rebuild them >> completely. > > This is an interesting question as I am facing a similar issue at present. > > I have a bunch of Version80 databases with full text catalogs on SQL > Server > 2000 servers that are going to be moved to a SQL Server 2005 cluster. The > intention is to keep them as Version80 databases (for the most part) and > the > intention was to carry the full text catalog across to save rebuilding > them. > However it seems that even though the database remains as Version80 I need > to > rebuild the catalog anyway. > > Is that what you think? It seems to be the case from my testing though I > have to say that my understanding of full text indexing is less than > complete.
