Is it possible? Combining Database Content Source and File System Content Source...

Question

Hello everyone,

I was wondering if there was a way in Search Server Express to combine results from the file system and a database?  We are thinking of creating an application (small DMS I guess) that will have files stored on the file system that we want to crawl and then having meta-data stored for each document in a database that we also want to crawl, but the search results to direct people to the documents the meta-data is for..  The documents are PDF files, AutoCad files, and various image format files.

Thanks in advanced,

Greg

Answer 1

Hello,
I used the federated search. I call an ASP file from the federated search and use a variable to give the query to my asp file. The ASP file takes a look in my SQL server (Select ... query) and builds a XML file for the Search results ...