I can’t seem to make SE 21.0.1.0 x64 remember a file extension mapping for 'sql'.
What I’d like is to be able open a *.sql file from Windows Explorer, and have it recognized as a Sql Server file. I have a right click context menu item in Windows "Open in Slickedit" that opens the right clicked file using this command: "C:\Program Files\SlickEdit Pro 21.0.1\win\vs.exe" "file.sql".
When opened this way, a *.sql file is opened as plain text, and not recognized as .sql, there’s no color coding or other language features.
Three settings seem like they should help, but they haven’t worked:
A. After opening the file, click the Document | Select Mode menu, and choose SQL Server. SE asks "Would you like to map all files with the extension of '.sql' to SQL Server?" Clicking Yes only works until SE is closed, when restarted, .sql files are recognized as plain text again.
B. In Tools | Options | Languages | Database Languages | SQL Server | General, click the Edit These Extensions button. Default values are 'sqlserver' and 'sybase', I add 'sql', then click OK. After closing the Options dialog and reopening, I verify the .sql extension has been added, but *.sql files opened from Windows (as opposed to from within SE) are still recognized as plain text.
As a bonus, the sql extension I just added goes away after closing and restarting SE.
C. In Tools | Options | Languages | File Extension Manager, add 'sql' and associate with Sql Server. Again I can verify it's added after reopening the Options dialog, but it's gone after closing and reopening SE.
My first thought was that somehow SE can’t write to its config folder, but files there are getting updated, e.g., vslick.sta, user.cfg.xml. Also, I can add other extensions, e.g. I added extension 'fred' and associated it with plain text. I was there after closing and restarting SE.
Any ideas would be appreciated.