Unable to add predfined style via active Style
Ropenfold
Posts: 1
in SQL Prompt
I am running Microsoft SQL Server Management Studio via a parallels VM on an iMac. I am unable to locate a formatting style which is clearly in the folder but does not come up on a search via Active Style -> Edit Styles and then searching via the style folder window. My other colleagues are not experiencing this issue. We have also noticed when I create a style it is in json instead of XML when I view this through Visual Studio Code. We unfortunately have no other staff who have this set up so I am hoping for some help on here. I don't know if this is an issue as I am running it through a VM.
Tagged:
Answers
SQL Prompt 10.5 and later use JSON files to store formatting styles. XML styles present in your styles directory will have automatically upgraded to the new format when upgrading to SQL Prompt 10.5.
If you need to manually upgrade an older XML file please see this support article: https://documentation.red-gate.com/sp10/sql-code-formatting-and-styles/updating-style-files-from-before-version-10-5
Thanks,
Owen
SQL Prompt / SQL Search