What sort of black magic and secret handshakes do I need to do to get .sql files searchable with SP Foundation 2013?

Specifically, how do I get files with the ".sql" extension be both indexed and CRAWL its CONTENTS?

I recall in 2010, you had to do a bit of hocus pocus to get PDFs working, but it worked provided you added the required adobe iFilter, and the needed registry voodoo.

With .SQL I thought it would be easier! They are basically glorified text files, so I figured the already existing plaintext iFilter would work, but it doesn't seem to take, even after trying to tell SP to use the plaintext filter for SQL files.

Steps I have taken:

  1. Added "sql" extension to SP via the "Manage File Types" menu in the Search Admin Panel
  2. Followed the suggestions in this MSDN Thread (Maybe I made a mistake here?)

Current Results:

If I search for a SQL file, I have to search the complete filename for the result to show up. e.g. search "MyAmazingFile" in order to return a link to "MyAmazingFile.sql". Neither the content of the sql file, nor a partial filename will return results.

Indexer say it has indexed the SQL files correctly, and reports no warnings or errors.

  • did you made changes to the Registry, then restart search services and lastly full crawl?
    – Waqas Sarwar MVP
    Commented Apr 26, 2014 at 6:14
  • Yes, I did this, but I havent tried PEr Jakonsen's suggestion. I will try it and report back.
    – Ray
    Commented Apr 28, 2014 at 3:22

1 Answer 1


In SP2013 you also need to run New-SPEnterpriseSearchFileFormat see HOW TO: Implement a custom iFilter in SharePoint 2013

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.