Friday, February 24, 2012

Full-text search other than database

I know how to create full-text indexing on database.
How about is it possible to do a full-text indexing on files like .doc, .xls
on a harddisk by SQL Server using SQL?
eg. I have a word document on
c:\temp\mywork.doc
and a spreadsheet on
c:\myschedule\schedule1.xlsYou can create a linked server to an indexing services catalog which should
contain the directories these file exist in.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OJAjgAMdGHA.2456@.TK2MSFTNGP04.phx.gbl...
>I know how to create full-text indexing on database.
> How about is it possible to do a full-text indexing on files like .doc,
> .xls
> on a harddisk by SQL Server using SQL?
> eg. I have a word document on
> c:\temp\mywork.doc
> and a spreadsheet on
> c:\myschedule\schedule1.xls
>|||Are you talking about create a linked server which is pointing to a folder ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMTrtwOdGHA.3840@.TK2MSFTNGP04.phx.gbl...
> You can create a linked server to an indexing services catalog which
should
> contain the directories these file exist in.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OJAjgAMdGHA.2456@.TK2MSFTNGP04.phx.gbl...
> >I know how to create full-text indexing on database.
> > How about is it possible to do a full-text indexing on files like .doc,
> > .xls
> > on a harddisk by SQL Server using SQL?
> >
> > eg. I have a word document on
> > c:\temp\mywork.doc
> > and a spreadsheet on
> > c:\myschedule\schedule1.xls
> >
> >
>

No comments:

Post a Comment