Unanswered: Saving a full text index to SQL server
Does anyone know a good solution to this problem?
I have a large filestore of all sorts of documents (word, PDF, OCR document scans, emails, etc)
I have a large SQL database that defines each of these documents (folder, parent folder, document owner, etc, etc)
I need to do combined searches over the full text of each of the documents, combined with the descriptive data of the documents that is stored in the SQL server.
Now, normally I would just use a distributed query to query both the index server and the SQL server. However I'm using a JDO enhancer to perform the query and this requires all the data to be contained within the SQL server.
Can I get the Index server to create its index in SQL tables?
Is there another way to combine the structured and unstructured data within SQL server.