全文搜索升级选项Full-Text Search Upgrade Options

使用 SQL ServerSQL Server 安装向导的“全文搜索升级选项”页选择用于此时要升级的数据库的全文搜索升级选项。Use the Full-Text Search Upgrade Options page of the SQL ServerSQL Server Installation Wizard to select the full-text search upgrade option to use for the databases that you are upgrading at this time.

SQL Server 2005SQL Server 2005 中,每个全文检索都驻留在属于文件组的全文目录中,它们均具有物理路径,并被视为数据库文件。In SQL Server 2005SQL Server 2005 each full-text index resides in a full-text catalog that belongs to a filegroup, has a physical path, and is treated as a database file. 现在,全文目录是一个逻辑概念的虚拟对象的是指一组全文索引。Now, a full-text catalog is a logical concept-a virtual object-that refers to a group of full-text indexes. 因此,新的全文目录不会视为带有物理路径的数据库文件。Therefore, a new full-text catalog is not treated as a database file with a physical path. 但是,在升级包含数据文件的所有全文目录期间,将在相同磁盘上创建新的文件组。However, during upgrade of any full-text catalog that contains data files, a new filegroup is created on same disk. 这可以在升级后维护旧磁盘的 I/O 行为。This maintains the old disk I/O behavior after upgrade. 该目录的所有全文检索均被放置到新的文件组中(如果存在根路径)。Any full-text index from that catalog is placed in the new filegroup if the root path exists. 如果旧的全文目录路径无效,该升级则将全文检索保留在与基表相同的文件组中,或者保留在主文件组中(对于分区表)。If the old full-text catalog path is invalid, the upgrade keeps the full-text index in the same filegroup as base table or, for a partitioned table, in the primary filegroup.


升级到 SQL Server 2014SQL Server 2014时,请选择下列全文升级选项之一。When you upgrade to SQL Server 2014SQL Server 2014, choose one of the following full-text upgrade options.

导入全文目录。Full-text catalogs are imported. 一般情况下,导入速度比重新生成速度要快很多。Typically, import is significantly faster than rebuild. 例如,当仅使用一个 CPU 时,导入的运行速度比重新生成要快 10 倍左右。For example, when using only one CPU, import runs about 10 times faster than rebuild. 不过,从 SQL Server 2005SQL Server 2005 导入的全文目录不能使用新的和增强的断字符,因此最终可能还是要重新生成全文目录。However, a full-text catalog imported from SQL Server 2005SQL Server 2005 does not use the new and enhanced word breakers, so you might want to rebuild your full-text catalogs eventually.


重新生成可以以多线程模式运行,如果可用的 CPU 在 10 个以上,且您允许重新生成操作使用所有这些 CPU,则重新生成操作的运行速度可能比导入更快。Rebuild can run in multi-threaded mode, and if more than 10 CPUs are available, rebuild might run faster than import if you allow rebuild to use all of the CPUs.

如果全文目录不可用,则会重新生成关联的全文检索。If a full-text catalog is not available, the associated full-text indexes are rebuilt. 此选项仅对 SQL Server 2005SQL Server 2005 数据库可用。This option is available for only SQL Server 2005SQL Server 2005 databases.

有关导入全文检索的影响的信息,请参阅本主题后面的“有关选择全文升级选项的注意事项”。For information about the impact of importing full-text index, see "Considerations for Choosing a Full-Text Upgrade Option," later in this topic.

使用新的和增强的断字符重新生成全文目录。Full-text catalogs are rebuilt using the new and enhanced word breakers. 重新生成索引可能需要许多时间,且升级后可能需要占用大量的 CPU 和内存。Rebuilding indexes can take a lot of time, and a significant amount of CPU and memory might be required after the upgrade.

重置全文目录。Full-text catalogs are reset. SQL Server 2005SQL Server 2005升级时,将删除全文目录文件,但会保留全文目录和全文检索的元数据。When upgrading from SQL Server 2005SQL Server 2005, full-text catalog files are removed, but the metadata for full-text catalogs and full-text indexes is retained. 在进行升级后,所有全文检索将禁用更改跟踪,并且不会自动启动爬网。After being upgraded, all full-text indexes are disabled for change tracking and crawls are not started automatically. 在升级完成后,目录将保留为空,直至手动执行完全填充。The catalog will remain empty until you manually issue a full population, after the upgrade completes.

所有这些升级选项确保升级后的数据库从全文性能增强功能中完全受益。All of these upgrade options ensure that upgraded databases benefit fully from full-text performance enhancements.

有关选择全文升级选项的注意事项Considerations for Choosing a Full-Text Upgrade Option

为升级选择升级选项时,请考虑以下几点:When choosing the upgrade option for your upgrade, consider the following:

  • 如何使用断字符?How do you use word breakers?

    SQL Server 2014SQL Server 2014 中的全文搜索服务包括断字符和词干分析器。The full-text search service in SQL Server 2014SQL Server 2014 includes word breakers and stemmers. 这可能更改 SQL Server 2005SQL Server 2005 中特定文本模式或方案的全文查询结果。These might change the results of full-text queries from SQL Server 2005SQL Server 2005 for a specific text pattern or scenario. 因此,在选择适当的升级选项时,如何使用断字符非常重要:Therefore, how you use word breakers is important when choosing a suitable upgrade option:

    • 如果使用的全文语言的断字符未发生更改,或者撤回准确性对您来说并不重要,则适合导入。If the word breakers of the full-text language you use did not change, or if recall accuracy is not critical to you, importing is suitable. 随后,如果遇到任何撤回问题,您只需通过重新生成全文目录即可升级到新的断字符。Later, if you experience any recall issues, you can upgrade to the new word breakers simply by rebuilding your full-text catalogs.

    • 如果您关心撤回准确性,并使用 SQL Server 2005SQL Server 2005后已添加的断字符之一,则适合重新生成。If you care about recall accuracy and you use one of the word breakers that were added after SQL Server 2005SQL Server 2005, rebuilding is suitable.

  • 是否基于整数全文键列生成了任何全文检索?Were any full-text indexes built on integer full-text key columns?

    重新生成执行内部优化,在某些情况下该优化可提高升级的全文检索的查询性能。Rebuilding performs internal optimizations that improve the query performance of the upgraded full-text index in some cases. 具体来说,如果您具有的全文目录包含基表的全文键列为整数数据类型的全文检索,则重新生成将在升级后实现全文查询的理想性能。Specifically, if you have full-text catalogs that contain full-text indexes for which the full-text key column of the base table is an integer data type, rebuilding achieves ideal performance of full-text queries after upgrade. 在这种情况下,我们强烈建议使用 “重新生成” 选项。In this case, we highly recommend you to use the Rebuild option.


    对于 SQL Server 2014SQL Server 2014中的全文索引,建议采用整数数据类型作为全文键列。For full-text indexes in SQL Server 2014SQL Server 2014, we recommend that the column serving as the full-text key be an integer data type. 有关详细信息,请参阅 改进全文索引的性能For more information, see Improve the Performance of Full-Text Indexes.

  • 使服务器实例处于联机状态的优先级是什么?What is the priority for getting your server instance online?

    升级期间的导入或重新生成操作会占用很多 CPU 资源,这会延迟其余服务器实例的升级和联机。Importing or rebuilding during upgrade takes a lot of CPU resources, which delays getting the rest of the server instance upgraded and online. 如果使服务器实例尽快处于联机状态非常重要,并且希望在升级后运行手动填充,则适合 “重置”If getting the server instance online as soon as possible is important and if you are willing to run a manual population after the upgrade, Reset is suitable.

其他资源Additional Resources