Manual Migration of Settings from SQL Prompt v10 to v11
Published 29 May 2025
While upgrading from SQL Prompt v10 to v11, if it is not a clean upgrade, certain settings may not be copied automatically. If you encounter this issue, you can manually copy the settings by following these steps:
1. Copy Code Analysis Settings
Copy the 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 Snippets
Copy the 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 Styles
Copy the 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 Configuration Files
Copy the following files from:
C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\
to:
C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\
- ConnectionColoringCategories.xml
- ConnectionColoringServers.xml
- RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
- RedGate_SqlPrompt_Engine_EngineOptions.xml