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:
- Added "sql" extension to SP via the "Manage File Types" menu in the Search Admin Panel
- Followed the suggestions in this MSDN Thread (Maybe I made a mistake here?)
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.