Installazione di ricerca Full-Text SQL Server in LinuxInstall SQL Server Full-Text Search on Linux

In questo argomento si applica a: SìSQL Server (solo Linux)nonDatabase SQL di AzurenonAzure SQL Data WarehousenonParallel Data WarehouseTHIS TOPIC APPLIES TO: yesSQL Server (Linux only)noAzure SQL DatabasenoAzure SQL Data WarehousenoParallel Data Warehouse

Installare i seguenti passaggi ricerca Full-Text di SQL Server (mssql-server-fts) in Linux.The following steps install SQL Server Full-Text Search (mssql-server-fts) on Linux. Ricerca full-Text consente di eseguire query full-text su dati di tipo carattere nelle tabelle di SQL Server.Full-Text Search enables you to run full-text queries against character-based data in SQL Server tables. Per i problemi noti per questa versione, vedere il note sulla versione.For known issues for this release, see the Release Notes.

Nota

Prima di installare prima di ricerca Full-Text di SQL Server, installare SQL Server.Before installing SQL Server Full-Text Search, first install SQL Server. Ciò consente di configurare le chiavi e i repository che durante l'installazione di mssql-server-fts pacchetto.This configures the keys and repositories that you use when installing the mssql-server-fts package.

Installare ricerca Full-Text di SQL Server per la piattaforma:Install SQL Server Full-Text Search for your platform:

Installare su RHELInstall on RHEL

Utilizzare i comandi seguenti per installare il mssql-server-fts su 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 si dispone già di mssql-server-fts installato, è possibile aggiornare la versione più recente con i comandi seguenti: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 occorre un'installazione offline, individuare il download del pacchetto nella ricerca Full-text di note sulla versione.If you need an offline installation, locate the Full-text Search package download in the Release notes. Quindi utilizzare gli stessi passaggi di installazione offline descritti nell'argomento installazione di SQL Server.Then use the same offline installation steps described in the topic Install SQL Server.

Installare in UbuntuInstall on Ubuntu

Utilizzare i comandi seguenti per installare il mssql-server-fts in 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 si dispone già di mssql-server-fts installato, è possibile aggiornare la versione più recente con i comandi seguenti: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 occorre un'installazione offline, individuare il download del pacchetto nella ricerca Full-text di note sulla versione.If you need an offline installation, locate the Full-text Search package download in the Release notes. Quindi utilizzare gli stessi passaggi di installazione offline descritti nell'argomento installazione di SQL Server.Then use the same offline installation steps described in the topic Install SQL Server.

Installare in SLESInstall on SLES

Utilizzare i comandi seguenti per installare il mssql-server-fts in 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 si dispone già di mssql-server-fts installato, è possibile aggiornare la versione più recente con i comandi seguenti: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 occorre un'installazione offline, individuare il download del pacchetto nella ricerca Full-text di note sulla versione.If you need an offline installation, locate the Full-text Search package download in the Release notes. Quindi utilizzare gli stessi passaggi di installazione offline descritti nell'argomento installazione di SQL Server.Then use the same offline installation steps described in the topic Install SQL Server.

Lingue supportateSupported languages

Ricerca full-Text utilizza word breaker che determinano come identificare singole parole basate sul linguaggio.Full-Text Search uses word breakers that determine how to identify individual words based on language. È possibile ottenere un elenco di word breaker registrati eseguendo una query di Sys. fulltext_languages vista del catalogo.You can get a list of registered word breakers by querying the sys.fulltext_languages catalog view. Con SQL Server 2017 vengono installati i Word breaker per le lingue seguenti:Word breakers for the following languages are installed with SQL Server 2017:

LinguaggioLanguage ID di linguaLanguage ID
Lingua neutraNeutral 00
AraboArabic 10251025
Bengali (India)Bengali (India) 10931093
BokmålBokmål 10441044
Portoghese (Brasile)Brazilian 10461046
Inglese (Regno Unito)British English 20572057
BulgaroBulgarian 10261026
CatalanoCatalan 10271027
Cinese (Hong Kong - R.A.S., Repubblica popolare cinese)Chinese (Hong Kong SAR, PRC) 30763076
Cinese (Macao - R.A.S.)Chinese (Macao SAR) 51245124
Cinese (Singapore)Chinese (Singapore) 41004100
CroatoCroatian 10501050
CecoCzech 10291029
DaneseDanish 10301030
OlandeseDutch 10431043
IngleseEnglish 10331033
FranceseFrench 10361036
TedescoGerman 10311031
GrecoGreek 10321032
GujaratiGujarati 10951095
HebrewHebrew 10371037
HindiHindi 10811081
IslandeseIcelandic 10391039
IndonesianoIndonesian 10571057
ItalianoItalian 10401040
GiapponeseJapanese 10411041
KannadaKannada 10991099
CoreanoKorean 10421042
LettoneLatvian 10621062
LituanoLithuanian 10631063
Malese (Malesia)Malay - Malaysia 10861086
MalayalamMalayalam 11001100
MarathiMarathi 11021102
PolaccoPolish 10451045
PortoghesePortuguese 20702070
PunjabiPunjabi 10941094
RomenoRomanian 10481048
RussoRussian 10491049
Serbo (alfabeto cirillico)Serbian (Cyrillic) 30983098
Serbo (alfabeto latino)Serbian (Latin) 20742074
Cinese semplificatoSimplified Chinese 20522052
SlovaccoSlovak 10511051
SlovenoSlovenian 10601060
SpagnoloSpanish 30823082
SvedeseSwedish 10531053
TamilTamil 10971097
TeluguTelugu 10981098
ThaiThai 10541054
Cinese tradizionaleTraditional Chinese 10281028
TurcoTurkish 10551055
UcrainoUkrainian 10581058
UrduUrdu 10561056
VietnamitaVietnamese 10661066

FiltriFilters

Ricerca full-Text funziona anche con il testo archiviato in file binari.Full-Text Search also works with text stored in binary files. Ma in questo caso, un filtro installato è necessario elaborare il file.But in this case, an installed filter is required to process the file. Per ulteriori informazioni sui filtri, vedere configurare e gestire i filtri per la ricerca.For more information about filters, see Configure and Manage Filters for Search.

È possibile visualizzare un elenco di filtri installati chiamando sp_help_fulltext_system_components 'filter'.You can see a list of installed filters by calling sp_help_fulltext_system_components 'filter'. Per SQL Server 2017, vengono installati i seguenti filtri:For SQL Server 2017, the following filters are installed:

Nome componenteComponent Name ID classeClass ID VersioneVersion
con estensione.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
con estensione 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
con estensione 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
file con estensione 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
Con estensione 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
con estensione 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
con estensione tlh.tlh C1243CA0-BF96-11CD-B579-08002B30BFEBC1243CA0-BF96-11CD-B579-08002B30BFEB 12.0.6828.012.0.6828.0
con estensione 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
file con estensione 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
con estensione 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
e 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

Ricerca semantica si basa sulla funzionalità di ricerca Full-Text per estrarre e indice statisticamente pertinenti frasi chiave.Semantic Search builds on the Full-Text Search feature to extract and index statistically relevant key phrases. Ciò consente di eseguire una query il significato all'interno di documenti nel database.This enables you to query the meaning within documents in your database. Consente inoltre di identificare documenti simili.It also helps to identify documents that are similar.

Per utilizzare la ricerca semantica, è necessario innanzitutto ripristinare il database di statistiche lingua semantica nel computer in uso.In order to use Semantic Search, you must first restore the Semantic Language Statistics database to your machine.

  1. Utilizzare uno strumento, ad esempio sqlcmd, per eseguire il comando Transact-SQL seguente sull'istanza del Server SQL di Linux.Use a tool, such as sqlcmd, to run the following Transact-SQL command on your Linux SQL Server instance. Questo comando Ripristina il database di statistiche lingua.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
    

    Nota

    Se necessario, aggiornare i percorsi nel comando RESTORE precedente in modo che la configurazione.If necessary, update the paths in the previous RESTORE command to adjust for your configuration.

  2. Eseguire il comando Transact-SQL seguente per registrare il database di statistiche lingua semantica.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
    

Passaggi successiviNext steps

Per informazioni sulla ricerca Full-Text, vedere ricerca Full-Text di SQL Server.For information about Full-Text Search, see SQL Server Full-Text Search.