title: Azure Searching On File Attachments same as Oracle table using a file link in a column
body: <p>I am trying to get some Oracle databases to work in MSSQL AZURE.</p>
  <p>We seem to have most things working except the ability to search on file attachments - eg word,PDF etc.</p>
  <p>Oracle lets us index a column in a table that uses a filepath link.</p>
  <p>In MSSQL a column in a table can be added using:</p>
  <p>[filepointer] VARBINARY(MAX) FILESTREAM
  and then an index can be setup so files can then be searched.</p>
  <p>I'm trying to use the same oracle table with this extra column to do the search in AZURE</p>
  <p>EG - select * from [TESTATTACHSRCH]  where contains ([filepointer],'Text in File')</p>
  <p>I managed to get this working in MSSQL with the Oracle table we had used with this extra special column.</p>
  <p>I know at this point FILESTREAM is not supported on AZURE &amp; dropping FILESTREAM is not an option due to the size of the files we are searching on which would add too much size to the database.</p>
  <p>I am hoping if there was a way i could still achieve this on AZURE, even if existing AZURE cannot do this on its own &amp; there was 3rd party software to do something similar.</p>
  <p>Hopefully somebody has hit the same roadblock &amp; could provide some advice</p>
  <p>Thanks</p>