SQL Prompt 11 is now available:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-11-0-release-notes
11.0.0.16715 - Released on 28th May 2025
Features
- Added support for SQL Server Management Studio 21.
- Added support for Synapse Dedicated SQL Pools.
Please note that there is a known issue with certain settings not being automatically copied over to the new version. We would suggest copying these settings manually from v10 folder to v11 folder by following below steps:
1. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\CodeAnalysis to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\CodeAnalysis
2. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Snippets to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Snippets
3. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Styles to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Styles
4. Copy ConnectionColoringCategories.xml, ConnectionColoringServers.xml, RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml, RedGate_SqlPrompt_Engine_EngineOptions.xml files from C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\
Microsoft has aligned SSMS 21 UI to VS 2022. The SQL Prompt option now appears in the SSMS 21 Extensions menu:
Extensions
To move the SQL Prompt menu to the top-level menu, select Extensions | Customize Menu...
Then uncheck the checkbox next to the SQL Prompt item in the list.
SQL Prompt 11 is now available:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-11-0-release-notes
Please note that there is a known issue with certain settings not being automatically copied over to the new version. We would suggest copying these settings manually from v10 folder to v11 folder by following below steps:
1. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\CodeAnalysis to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\CodeAnalysis
2. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Snippets to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Snippets
3. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Styles to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Styles
4. Copy ConnectionColoringCategories.xml, ConnectionColoringServers.xml, RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml, RedGate_SqlPrompt_Engine_EngineOptions.xml files from C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\
Microsoft has aligned SSMS 21 UI to VS 2022. The SQL Prompt option now appears in the SSMS 21 Extensions menu:
Extensions
To move the SQL Prompt menu to the top-level menu, select Extensions | Customize Menu...
Then uncheck the checkbox next to the SQL Prompt item in the list.