在 Linux 上安装 SQL Server 全文搜索Install SQL Server Full-Text Search on Linux

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Linux适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Linux

下列步骤介绍在 Linux 上安装SQL Server 全文搜索 (mssql-server-fts) 。The following steps install SQL Server Full-Text Search (mssql-server-fts) on Linux. 全文搜索提供了对 SQL Server 表中基于字符的数据运行全文查询的功能。Full-Text Search enables you to run full-text queries against character-based data in SQL Server tables. 对于此版本的已知问题,请参阅发行说明For known issues for this release, see the Release Notes.

备注

在安装 SQL Server 全文搜索前,首先请安装 SQL ServerBefore installing SQL Server Full-Text Search, first install SQL Server. 这将配置安装 mssql-server-fts 包时要用到的密钥和存储库 。This configures the keys and repositories that you use when installing the mssql-server-fts package.

为以下平台安装 SQL Server 全文搜索:Install SQL Server Full-Text Search for your platform:

在 RHEL 上安装Install on RHEL

通过下列命令在 Red Hat Enterprise Linux 上安装 mssql-server-fts 。Use the following commands to install the mssql-server-fts on Red Hat Enterprise Linux.

sudo yum install -y mssql-server-fts

如果已安装 mssql-server-fts,可使用下列命令将其更新至最新版本 :If you already have mssql-server-fts installed, you can update to the latest version with the following commands:

sudo yum check-update
sudo yum update mssql-server-fts

如果需要脱机安装,请在发行说明中找到全文搜索包下载。If you need an offline installation, locate the Full-text Search package download in the Release notes. 然后执行与文章安装 SQL Server 所述相同的脱机安装步骤。Then use the same offline installation steps described in the article Install SQL Server.

在 Ubuntu 上安装Install on Ubuntu

通过下列命令在 Ubuntu 上安装 mssql-server-fts 。Use the following commands to install the mssql-server-fts on Ubuntu.

sudo apt-get update 
sudo apt-get install -y mssql-server-fts

如果已安装 mssql-server-fts,可使用下列命令将其更新至最新版本 :If you already have mssql-server-fts installed, you can update to the latest version with the following commands:

sudo apt-get update 
sudo apt-get install -y mssql-server-fts 

如果需要脱机安装,请在发行说明中找到全文搜索包下载。If you need an offline installation, locate the Full-text Search package download in the Release notes. 然后执行与文章安装 SQL Server 所述相同的脱机安装步骤。Then use the same offline installation steps described in the article Install SQL Server.

在 SLES 上安装Install on SLES

通过下列命令在 SUSE Linux Enterprise Server 上安装 mssql-server-fts 。Use the following commands to install the mssql-server-fts on SUSE Linux Enterprise Server.

sudo zypper install mssql-server-fts

如果已安装 mssql-server-fts,可使用下列命令将其更新至最新版本 :If you already have mssql-server-fts installed, you can update to the latest version with the following commands:

sudo zypper refresh
sudo zypper update mssql-server-fts

如果需要脱机安装,请在发行说明中找到全文搜索包下载。If you need an offline installation, locate the Full-text Search package download in the Release notes. 然后执行与文章安装 SQL Server 所述相同的脱机安装步骤。Then use the same offline installation steps described in the article Install SQL Server.

支持的语言Supported languages

全文搜索使用分词系统来确定如何标识基于语言的单个单词。Full-Text Search uses word breakers that determine how to identify individual words based on language. 可通过查询 sys.fulltext_languages 目录视图获取注册的分词系统列表 。You can get a list of registered word breakers by querying the sys.fulltext_languages catalog view. SQL Server 已安装以下语言的分词系统:Word breakers for the following languages are installed with SQL Server:

语言Language 语言 IDLanguage ID
中立Neutral 00
阿拉伯语Arabic 10251025
孟加拉语(印度)Bengali (India) 10931093
书面挪威语Bokmål 10441044
葡萄牙语(巴西)Portuguese (Brazil) 10461046
英语(英国)British English 20572057
保加利亚语Bulgarian 10261026
加泰罗尼亚语Catalan 10271027
中文(香港特别行政区)Chinese (Hong Kong SAR, PRC) 30763076
中文(澳门特别行政区)Chinese (Macao SAR) 51245124
中文(新加坡)Chinese (Singapore) 41004100
克罗地亚语Croatian 10501050
捷克语Czech 10291029
丹麦语Danish 10301030
荷兰语Dutch 10431043
英语English 20521033
法语French 10361036
德语German 10311031
希腊语Greek 10321032
古吉拉特语Gujarati 10951095
希伯来语Hebrew 10371037
HindiHindi 10811081
冰岛语Icelandic 10391039
印度尼西亚语Indonesian 10571057
意大利语Italian 10401040
日语Japanese 10411041
卡纳达语Kannada 10991099
韩语Korean 10421042
拉脱维亚语Latvian 10621062
立陶宛语Lithuanian 10631063
马来语(马来西亚)Malay - Malaysia 10861086
马拉雅拉姆语Malayalam 11001100
马拉地语Marathi 11021102
波兰语Polish 10451045
葡萄牙语Portuguese 20702070
旁遮普语Punjabi 10941094
罗马尼亚语Romanian 10481048
俄语Russian 10491049
塞尔维亚语(西里尔)Serbian (Cyrillic) 30983098
塞尔维亚语(拉丁)Serbian (Latin) 20742074
简体中文Simplified Chinese 20522052
斯洛伐克语Slovak 10511051
斯洛文尼亚语Slovenian 10601060
西班牙语Spanish 30823082
瑞典语Swedish 10531053
泰米尔语Tamil 10971097
泰卢固语Telugu 10981098
泰语Thai 10541054
繁体中文Traditional Chinese 10281028
土耳其语Turkish 10551055
乌克兰语Ukrainian 10581058
乌尔都语Urdu 10561056
越南语Vietnamese 10661066

筛选器Filters

全文搜索还适用于二进制文件中存储的文本。Full-Text Search also works with text stored in binary files. 但在这种情况下,需要安装一个筛选器来处理文件。But in this case, an installed filter is required to process the file. 有关筛选器的详细信息,请参阅配置和管理搜索筛选器For more information about filters, see Configure and Manage Filters for Search.

可调用 sp_help_fulltext_system_components 'filter' 来查看已安装的筛选器列表 。You can see a list of installed filters by calling sp_help_fulltext_system_components 'filter'. 对于 SQL Server,已安装的筛选器包括:For SQL Server, the following filters are installed:

组件名称Component Name 类 IDClass ID 版本Version
.a.a C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.ans.ans C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.asc.asc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.ascx.ascx E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.asm.asm C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.asp.asp E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.aspx.aspx E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.asx.asx C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.bas.bas C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.bat.bat C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.bcp.bcp C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.c.c C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.cc.cc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.cls.cls C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.cmd.cmd C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.cpp.cpp C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.cs.cs C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.csa.csa C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.css.css E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.csv.csv C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.cxx.cxx C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.dbs.dbs C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.def.def C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.dic.dic C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.dos.dos C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.dsp.dsp C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.dsw.dsw C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.ext.ext C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.faq.faq C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.fky.fky C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.h.h C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.hhc.hhc E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.hpp.hpp C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.hta.hta E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.htm.htm E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.html.html E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.htt.htt E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.htw.htw E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.htx.htx E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.hxx.hxx C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.i.i C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.ibq.ibq C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.ics.ics C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.idl.idl C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.idq.idq C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.inc.inc C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.inf.inf C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.ini.ini C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.inl.inl C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.inx.inx C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.jav.jav C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.java.java C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.js.js C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.kci.kci C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.lgn.lgn C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.log.log C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.lst.lst C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.m3u.m3u C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.mak.mak C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.mk.mk C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.odc.odc E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.odh.odh C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.odl.odl C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.pkgdef.pkgdef C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.pkgundef.pkgundef C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.pl.pl C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.prc.prc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.rc.rc C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.rc2.rc2 C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.rct.rct C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.reg.reg C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.rgs.rgs C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.rtf.rtf C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.rul.rul C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.s.s C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.scc.scc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.shtm.shtm E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.shtml.shtml E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.snippet.snippet C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.sol.sol C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.sor.sor E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.srf.srf E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.stm.stm E0CA5340-4534-11CF-B952-00AA0051FE20E0CA5340-4534-11CF-B952-00AA0051FE20 12.0.6828.012.0.6828.0
.tab.tab C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.tdl.tdl C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.tlh.tlh C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.tli.tli C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.trg.trg C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.txt.txt C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.udf.udf C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.udt.udt C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.url.url C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.usr.usr C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vbs.vbs C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.viw.viw C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vsct.vsct C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vsixlangpack.vsixlangpack C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vsixmanifest.vsixmanifest C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vspscc.vspscc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vsscc.vsscc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.vssscc.vssscc C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.wri.wri C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
.wtx.wtx C7310720-AC80-11D1-8DF3-00C04FB6EF4FC7310720-AC80-11D1-8DF3-00C04FB6EF4F 12.0.6828.012.0.6828.0
.xml.xml 41B9BE05-B3AF-460C-BF0B-2CDD44A093B141B9BE05-B3AF-460C-BF0B-2CDD44A093B1 12.0.9735.012.0.9735.0

语义搜索建立在全文搜索功能的基础上,用于提取和索引与统计相关的关键短语 。Semantic Search builds on the Full-Text Search feature to extract and index statistically relevant key phrases. 这使你能查询数据库中文档内的含义。This enables you to query the meaning within documents in your database. 它还有助于标识其他类似的文档。It also helps to identify documents that are similar.

要使用语义搜索,必须先将语义语言统计信息数据库还原到你的计算机。In order to use Semantic Search, you must first restore the Semantic Language Statistics database to your machine.

  1. 使用工具,如 sqlcmd 在 Linux SQL Server 实例上运行以下 Transact-SQL 命令。Use a tool, such as sqlcmd, to run the following Transact-SQL command on your Linux SQL Server instance. 此命令还原语言统计信息数据库。This command restores the Language Statistics database.

    RESTORE DATABASE [semanticsdb] FROM
    DISK = N'/opt/mssql/misc/semanticsdb.bak' WITH FILE = 1,
    MOVE N'semanticsdb' TO N'/var/opt/mssql/data/semanticsDB.mdf',
    MOVE N'semanticsdb_log' TO N'/var/opt/mssql/data/semanticsdb_log.ldf', NOUNLOAD, STATS = 5
    GO
    

    备注

    如有必要,请更新上一个“还原”命令中的路径以调整你的配置。If necessary, update the paths in the previous RESTORE command to adjust for your configuration.

  2. 运行以下 Transact-SQL 命令,注册语义语言统计信息数据库。Run the following Transact-SQL command to register the semantic language statistics database.

    EXEC sp_fulltext_semantic_register_language_statistics_db @dbname = N'semanticsdb';  
    GO
    

后续步骤Next steps

有关全文搜索的相关信息,请参阅 SQL Server 全文搜索For information about Full-Text Search, see SQL Server Full-Text Search.