Oracle
The required Oracle Text index is part of a standard Oracle configuration.
Depending on the operating system in use, it might be necessary to add an appropriate XPS extension.
SQL Server
Check the availability of the SQL Full Text index on your system.
Information on full-text search can be found here:
http://msdn.microsoft.com/en-us/library/ms403375%28SQL.90%29.aspx
http://technet.microsoft.com/en-us/library/ms142497.aspx
http://technet.microsoft.com/en-us/library/ms142499.aspx
IFilters
The search inside binary files requires IFilters, for example for .PDF and MS Office files:
Adobe PDF IFilter 9 (64-bit) |
Link: ftp://ftp.adobe.com/pub/adobe/acrobat/win/9.x/
File name: PDFiFilter64Installer.zip |
Microsoft Office 2010 Filter Packs | http://www.microsoft.com/download/en/details.aspx?id=17062 |
Microsoft XPS Viewer (Windows 7, Windows 2008 Server) | Make sure the MS XPS Viewer is installed or, in Windows 2008 R2, the corresponding feature is enabled. |
-
Download and install the appropriate filters.
-
Execute this code on your SQL Server:
exec sp_fulltext_service 'load_os_resources', 1; exec sp_fulltext_service 'verify_signature', 0; go
-
Restart SQL server and check if IFilters are installed, for example .PDF and .DOCX.
exec sp_help_fulltext_system_components 'filter';
XPS Extension
Depending on the operating system in use, it might be necessary to add an appropriate XPS extension.