Instalar a pesquisa de texto completo do SQL Server no LinuxInstall SQL Server Full-Text Search on Linux

APLICA-SE A: simSQL Server (somente Linux) nãoBanco de Dados SQL do Azure nãoAzure Synapse Analytics (SQL DW) nãoParallel Data Warehouse APPLIES TO: yesSQL Server (Linux only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

As etapas a seguir instalam a Pesquisa de Texto Completo do SQL Server (mssql-server-fts) em Linux.The following steps install SQL Server Full-Text Search (mssql-server-fts) on Linux. A Pesquisa de Texto Completo permite que você execute consultas de texto completo em dados baseados em caracteres em tabelas SQL Server.Full-Text Search enables you to run full-text queries against character-based data in SQL Server tables. Para problemas conhecidos desta versão, veja as Notas sobre a versão.For known issues for this release, see the Release Notes.

Observação

Antes de instalar a Pesquisa de Texto Completo do SQL Server, primeiro instale o SQL Server.Before installing SQL Server Full-Text Search, first install SQL Server. Isso configura as chaves e os repositórios que você usa ao instar o pacote mssql-server-fts.This configures the keys and repositories that you use when installing the mssql-server-fts package.

Instale a Pesquisa de Texto Completo do SQL Server para sua plataforma:Install SQL Server Full-Text Search for your platform:

Instalar no RHELInstall on RHEL

Use os seguintes comandos para instalar o mssql-server-fts no Red Hat Enterprise Linux.Use the following commands to install the mssql-server-fts on Red Hat Enterprise Linux.

sudo yum install -y mssql-server-fts

Se você já tiver mssql-server-fts instalado, poderá atualizar para a versão mais recente com os seguintes comandos: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

Se você precisar de uma instalação offline, localize o download do pacote de Pesquisa de Texto Completo nas Notas sobre a versão.If you need an offline installation, locate the Full-text Search package download in the Release notes. Em seguida, use as mesmas etapas de instalação offline descritas no artigo Instalar o SQL Server.Then use the same offline installation steps described in the article Install SQL Server.

Instalar no UbuntuInstall on Ubuntu

Use os seguintes comandos para instalar o mssql-server-fts no Ubuntu.Use the following commands to install the mssql-server-fts on Ubuntu.

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

Se você já tiver mssql-server-fts instalado, poderá atualizar para a versão mais recente com os seguintes comandos: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 

Se você precisar de uma instalação offline, localize o download do pacote de Pesquisa de Texto Completo nas Notas sobre a versão.If you need an offline installation, locate the Full-text Search package download in the Release notes. Em seguida, use as mesmas etapas de instalação offline descritas no artigo Instalar o SQL Server.Then use the same offline installation steps described in the article Install SQL Server.

Instalar no SLESInstall on SLES

Use o seguinte comando para instalar o mssql-server-fts no SUSE Linux Enterprise Server.Use the following commands to install the mssql-server-fts on SUSE Linux Enterprise Server.

sudo zypper install mssql-server-fts

Se você já tiver mssql-server-fts instalado, poderá atualizar para a versão mais recente com os seguintes comandos: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

Se você precisar de uma instalação offline, localize o download do pacote de Pesquisa de Texto Completo nas Notas sobre a versão.If you need an offline installation, locate the Full-text Search package download in the Release notes. Em seguida, use as mesmas etapas de instalação offline descritas no artigo Instalar o SQL Server.Then use the same offline installation steps described in the article Install SQL Server.

Idiomas com suporteSupported languages

A Pesquisa de Texto Completo usa separadores de palavras que determinam como identificar palavras individuais com base no idioma.Full-Text Search uses word breakers that determine how to identify individual words based on language. Você pode obter uma lista de separadores de palavras registrados consultando a exibição do catálogo sys.fulltext_languages.You can get a list of registered word breakers by querying the sys.fulltext_languages catalog view. Os separadores de palavras para os seguintes idiomas são instalados com o SQL Server:Word breakers for the following languages are installed with SQL Server:

LinguagemLanguage ID do idiomaLanguage ID
NeutroNeutral 00
ÁrabeArabic 10251025
Bengali (India)Bengali (India) 10931093
BokmålBokmål 10441044
Português (Brasil)Portuguese (Brazil) 10461046
British EnglishBritish English 20572057
BúlgaroBulgarian 10261026
CatalãoCatalan 10271027
Chinês (RAE de Hong Kong, RPC)Chinese (Hong Kong SAR, PRC) 30763076
Chinese (Macao SAR)Chinese (Macao SAR) 51245124
Chinês (Singapura)Chinese (Singapore) 41004100
CroataCroatian 10501050
CzechCzech 10291029
DanishDanish 10301030
HolandêsDutch 10431043
InglêsEnglish 10461033
FrancêsFrench 10361036
GermanGerman 10311031
GreekGreek 10321032
GuzeratiGujarati 10951095
HebraicoHebrew 10371037
HíndiHindi 10811081
IslandêsIcelandic 10391039
IndonésioIndonesian 10571057
ItalianoItalian 10401040
JaponêsJapanese 10411041
canarimKannada 10991099
CoreanoKorean 10421042
LetãoLatvian 10621062
LituanoLithuanian 10631063
Malay - MalaysiaMalay - Malaysia 10861086
MalaialaMalayalam 11001100
MaratiMarathi 11021102
PolonêsPolish 10451045
PortuguêsPortuguese 20702070
PunjabiPunjabi 10941094
RomenoRomanian 10481048
RussoRussian 10491049
Serbian (Cyrillic)Serbian (Cyrillic) 30983098
Serbian (Latin)Serbian (Latin) 20742074
Chinês simplificadoSimplified Chinese 20522052
EslovacoSlovak 10511051
EslovenoSlovenian 10601060
EspanholSpanish 30823082
SuecoSwedish 10531053
TâmilTamil 10971097
TélugoTelugu 10981098
TailandêsThai 10541054
Chinês tradicionalTraditional Chinese 10281028
TurcoTurkish 10551055
UcranianoUkrainian 10581058
UrduUrdu 10561056
VietnamitaVietnamese 10661066

Filtros Filters

A Pesquisa de Texto Completo também funciona com texto armazenado em arquivos binários.Full-Text Search also works with text stored in binary files. Mas, nesse caso, um filtro instalado é necessário para processar o arquivo.But in this case, an installed filter is required to process the file. Para obter mais informações, confira Configurar e gerenciar filtros para pesquisa.For more information about filters, see Configure and Manage Filters for Search.

Você pode ver uma lista de filtros instalados chamando sp_help_fulltext_system_components 'filter' .You can see a list of installed filters by calling sp_help_fulltext_system_components 'filter'. Para o SQL Server, os filtros a seguir são instalados:For SQL Server, the following filters are installed:

Nome do ComponenteComponent Name ID da ClasseClass ID VersãoVersion
.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

A Pesquisa Semântica baseia-se no recurso de Pesquisa de Texto Completo para extrair e indexar frases-chave estatisticamente relevantes.Semantic Search builds on the Full-Text Search feature to extract and index statistically relevant key phrases. Isso permite que você consulte o significado dentro de documentos em seu banco de dados.This enables you to query the meaning within documents in your database. Também ajuda a identificar documentos semelhantes.It also helps to identify documents that are similar.

Para usar a Pesquisa Semântica, primeiro restaure o banco de dados Estatísticas Semânticas de Idioma em seu computador.In order to use Semantic Search, you must first restore the Semantic Language Statistics database to your machine.

  1. Use uma ferramenta, como sqlcmd, para executar o comando Transact-SQL a seguir em sua instância de SQL Server do Linux.Use a tool, such as sqlcmd, to run the following Transact-SQL command on your Linux SQL Server instance. Esse comando restaura o banco de dados de Estatísticas de Idioma.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
    

    Observação

    Se necessário, atualize os caminhos no comando RESTORE anterior para ajustar sua configuração.If necessary, update the paths in the previous RESTORE command to adjust for your configuration.

  2. Execute o seguinte comando Transact-SQL para registrar o banco de dados de estatísticas semânticas de idioma.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
    

Próximas etapasNext steps

Para obter informações sobre a Pesquisa de Texto Completo, confira Pesquisa de Texto Completo do SQL Server.For information about Full-Text Search, see SQL Server Full-Text Search.