Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-03-18 : 09:42:55
|
| How to migrate FULL TEXT indexes from SQL SERVER 2000 to 2005? Is it okay if I migrate the MSDB DB? Do i need to create the physical folders manually?------------------------I think, therefore I am - Rene Descartes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 19:51:30
|
| Full text index is nothing to do with msdb. If you migrate whole instance with in place migration, it'll take care of full text index. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-24 : 09:40:37
|
| Unfortunately, I am not migrating the whole instance. I believe – the information of the jobs which refresh the Full-text index gets stored in msdb. Am I missing something?------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 23:11:04
|
| Those jobs will not work if you don't migrate full text index. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-25 : 09:03:51
|
quote:
Originally posted by rmiao
Those jobs will not work if you don't migrate full text index.
How to migrate?------------------------I think, therefore I am - Rene Descartes |
|
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2008-03-25 : 15:54:53
|
| I would highly recommend that when upgrading from 2000 to 2005, you just simply re-create the full text indexes. Full-Text search is radically different in 2005, for example, you do not have to schedule updates anymore through agent, you can enable automatic change tracking.- Eric |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 23:34:49
|
| >> How to migrate?Migrate whole instance in place as I said above. |
|
|
|
|
|
|
Full text index migration