I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself.
I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol.
I have various formats of text documents residing on the FTP server. I need to create a fulltext index over these files to enable fulltext search of their content:
- Is it possible to create a fulltext index over this files without the need of the permanent local copy of files?
- If yes, is there any limitation which I should be aware of when creating context index over files which resides on FTP server? (file size limit, supported file types limitation)
- Is any incremental indexing possible(when I add new files to the FTP server I do not have to rebuild the whole index)?