Fulltext Search – SQL Server 2005 SP2

5 pts.
Tags:
FTP Server
SQL Server 2005
SQL Server 2005 administration
SQL Server Full Text Search
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 wihtout 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)? Regards, Michal

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Server full text indexing doesn’t allow for indexing files outside of the database. They would need to be loading into a table within the database for the SQL Server to index. You can use the Windows 2003 Indexing service to index files on a file server, however it doesn’t support indexing files on an FTP server. You would need a local copy of the files in question, or the ability to access the files over a Windows File share.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following