MSSQL full text search

An extensible full-text search is available for Postgres.

MSSQL full text search

1) install the 3MB MSOffice IFilters not included in the 3GB MSSQL (instructions)

Other formats can be supported, like PDF, ODF, etc.

2) You can verify file type support with this:

select * from sys.fulltext_document_types order by document_type;

3) Optionally if you have already uploaded files to noodle you should right click 'rebuild' the 'Databases/noodledb/Storage/Full Text Catalogs/BINARY_DATA' table.

Keep in mind you have to use the advanced search in Noodle and select the Full Text option to use the MSSQL FTS.

Related: configure MSSQL and migrate