Restore Style in SQLPrompt V.10 from SQLPrompt V.9

• 
  Hi pfaurevincent
  
  When upgrading to SQL Prompt 10.5 your old xml styles will have been stored in the following directory:  
  
  %localappdata%\Red Gate\SQL Prompt 10\StylesV2-backup
  
  Therefore you should be able to point your SQL Prompt 9 to look for styles in that directory in the Edit Formatting Styles window. 
  
  Please see this page for more information: https://documentation.red-gate.com/sp10/troubleshooting/downgrade-to-a-previous-version
  
  Thanks
  
  Owen

  ostandage December 18, 2020 08:59

  - 0 +
• 
  Hello Thank u but it's not cool when share style with lot of person good day

  pfaurevincent December 18, 2020 12:49

  - 0 +
• 
  Owen where can I download SQL Prompt 10.4 please ?

  pfaurevincent December 18, 2020 12:54

  - 0 +
• 
  Hi @pfaurevincent
  
  You can download SQL Prompt 10.4.7 here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.7.16599.exe
  
  Thanks,
  
  Owen

  ostandage December 18, 2020 14:07

  - 0 +
• 
  thanks good day :-)

  pfaurevincent December 18, 2020 14:11

  - 0 +
• 
  Hi,
  
  I'm sorry but you don't seem to have answered the original question.
  
  This is not good.  Are you saying that I now have to recreate our house styles and get them distributed to the team, just because you didn't bother to translate the XML format to JSON during a version upgrade?
  
  Kind Regards,
  
  Matt

  mattbenham December 21, 2020 12:44

  - 0 +
• 
  Hi @mattbenham
  
  Your formatting styles should have been automatically upgraded to the new format when upgrading to the latest version of SQL Prompt. If you're not already running SQL Prompt 10.5.3 please upgrade and check if your formatting styles are restored.
  
  If this doesn't solve your problem let us know and we will open a support ticket to assist you further.
  
  Thanks
  
  Owen

  ostandage December 21, 2020 13:16

  - 0 +
• 
  Thanks, I'm on 10.5.2 so I will try the update later.

  mattbenham December 21, 2020 13:18

  - 0 +
• 
  Hi, I upgraded from sqlprompt 9 to 10 (10.5.6.17542), the styles backup folder didn't get created as your previous post - %localappdata%\Red Gate\SQL Prompt 10\StylesV2-backup
  
  How do I convert the old xml format to the new json style format?
  
  Thanks

  mjcookie January 28, 2021 14:18

  - 0 +
• 
  Hi @mjcookie
  
  It is possible to manually upgrade formatting styles to the new format by following the steps here: https://documentation.red-gate.com/sp10/sql-code-formatting-and-styles/updating-style-files-from-before-version-10-5
  
  Thanks, 
  
  Owen

  ostandage February 01, 2021 09:07

  - 0 +

Add comment

Please sign in to leave a comment.