Upgrade Options in SQL Server 2008
When you upgrade SQL Server from a previous version to SQL Server 2008, or if you attach or restore a SQL 2005 database to SQL Server 2008, you are prompted to upgrade your full-text catalogs.
There are three options:
• Import
• Rebuild
• Reset
In an import, the full-text catalog is imported from the SQL Server 2005 instance in the case of an upgrade. In the case of a database attach or restore, the SQL 2005 full-text catalogs are stored in the database in a different file group.
An import is faster than a rebuild; however, the import does not use the new word breakers (described later), so for some languages where the word breakers have been improved, you may not get consistent results when compared with ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
