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

pfaurevincent

Good evening.
I have a problem restoring the style from  SQLPROMPT 9 to a SQLPROMPT10. 

The file in version 9 is in XML
and the file in version 10 is json.

Someone's already had this problem ?
thanks in advance

ostandage

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

pfaurevincent

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

pfaurevincent

Owen where can I download SQL Prompt 10.4 please ? 

ostandage

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

pfaurevincent

thanks good day :-)

mattbenham

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

ostandage

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

mattbenham

Thanks, I'm on 10.5.2 so I will try the update later.

mjcookie

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

ostandage

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