3rd party web search engine to sql?
-
Hi All,
I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).
My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.
Is there a third party or open source search engine available?
Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?
Many thanks,
Newbie
-
How about the one used right here on SQLServerCentral.com
http://www.imceda.com/SQLTurbo_Description.htm
--------------------
Colt 45 - the original point and click interface
-
Thanks Phill,
sounds good it we want to search large databases.
Our problem is a bit different. We need to search not just text within the database but within stored objects in the database, such as PDFs, DOC, PPT and so on.
Can this be done? We want to provide the user a search window that will show resultant hits from the abstracts (stored as text within the database) and also from the objects which may be a PDF and so on
Many thanks, really appreciate any help and guidance
-
If you're storing PDF, DOC and PPT files in the database, then they'll be stored as BLOBs. You'll need to either get a third party tool (or write on yourself) that scans the byte data, or extract the BLOB and scan it.
Personally, I don't like storing files in the database and this is one of the many reasons.
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply