Converting SQL Prompt Styles from V7 to V9

• 
  If you place the old style in the style folder before upgrading SQL Prompt, it will be auto-converted. 
  
  It sounds like you need to import old styles post-upgrade, there is a roundabout manner to make this happen: ‘Downgrade’ to SQL Prompt v7, place the style in the style folder, then upgrade again, at which point it will be auto-converted.

  
  

  
  

  Tianjiao_Li February 22, 2019 15:29

  - 0 +
• 
  Did as you said, nothing was upgraded, converted or changed.  Even the file types and timestamps did not alter.  Can you not just provide the executable to convert the settings on this forum?

  DevOpsGSC February 25, 2019 09:30

  - 0 +
• 
  That's odd. I've attached the console app. However, please bear in mind that it hasn't been kept up to date as it was normally not needed. 
  
  If you can attach your old style file, we can have a look for you.

  Tianjiao_Li February 27, 2019 10:25

  - 0 +
• 

  Tianjiao_Li said:

  That's odd. I've attached the console app. However, please bear in mind that it hasn't been kept up to date as it was normally not needed. 
  
  If you can attach your old style file, we can have a look for you. 

  Please find attached style needed for upgrade.
  
  

  DevOpsGSC February 27, 2019 10:30

  - 0 +
• 

  Apologies for not getting back sooner.

  Please find the converted style. It's normal that you might still need some manual adjustments as the behaviour of some format settings might have evolved.

  Tianjiao_Li March 04, 2019 10:00

  - 0 +
• 
  @DevOpsGSC
  
  It's good to know the converted style is working for you now. In case it might be useful for future cases, this is how I did it:
  
  1- uninstall Prompt and make sure any SQL Prompt folder is removed (can save them somewhere else in case need them later) from C:\Users\USERNAME\AppData\Local\Red Gate (this is important!)
  2- install Prompt 7, and place the style file in C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 7\Styles
  3- upgrade to Prompt 8, and check the style file was converted to C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 8\StylesV2 (this step might not be needed, but just wanted to be on the safe side)
  4- upgrade to Prompt 9, and check the style file was converted to C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 9\StylesV2
  5- checked the converted style file is working in Prompt 9
  

  Tianjiao_Li March 04, 2019 11:19

  - 0 +
• 

  Tianjiao_Li said:

  @DevOpsGSC
  
  It's good to know the converted style is working for you now. In case it might be useful for future cases, this is how I did it:
  
  1- uninstall Prompt and make sure any SQL Prompt folder is removed (can save them somewhere else in case need them later) from C:\Users\USERNAME\AppData\Local\Red Gate (this is important!)
  2- install Prompt 7, and place the style file in C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 7\Styles
  3- upgrade to Prompt 8, and check the style file was converted to C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 8\StylesV2 (this step might not be needed, but just wanted to be on the safe side)
  4- upgrade to Prompt 9, and check the style file was converted to C:\Users\USERNAME\AppData\Local\Red Gate\SQL Prompt 9\StylesV2
  5- checked the converted style file is working in Prompt 9
  

  Thank you for your input, whilst I appreciate the efforts and capturing the repro steps; this would be too much to ask of an end user to achieve an upgrade that should be implicit and reverse engineer-able. (IMHO)
  
  I did try these steps myself, without success (albeit the folder removal process was skipped) - and to then ask to repeat said process (uninstall, install, repeat) is again IMO something that should be offered without altering someones setup or software ideally a console app or Powershell script.
  
  Some feedback
  
  Ask yourself "What happens if person x from company y wants to achieve the same or similar" - you have to do this n times where n could be 1000, do you want to do that 1000 times or provide a single solution?
  
  Thanks again for doing the process on my behalf and getting my styles upgraded.
  
  

  DevOpsGSC March 04, 2019 11:40

  - 0 +

Add comment

Please sign in to leave a comment.