Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Arrow 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.

  2. #2
    Join Date
    Oct 2003
    Location
    Holland
    Posts
    8
    Hey

    U can use a OPENQUERY to query on INDEX SERVER. the result of that query can be used in a SQL Server query.

    To use this option you need to create a RemoteServer which redirects to a Index Server catalog.

    Example:

    SELECT P.Id,
    P.Name,
    Q.FileName,
    Q.Path
    FROM ( OPENQUERY(RemoteServerName,
    SELECT FileName,
    Path,
    Write,
    Rank,
    etc etc
    FROM SCOPE ( "e:\documents" )
    WHERE CONTAINS(Contents, 'searchword')
    )
    AS Q INNER JOIN P ON P.Id = Q.ID
    )

    Greetz Da Witte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •