Converting Styles from SQL Prompt 7 to 8

• 
  Can you upload the file for someone to examine?

  way0utwest October 26, 2017 22:22

  - 0 +
• 
  I tried to attach the file in its original format (.sqlpromptstyle) and .xml but I received an error message each time that the file was not allowed. Therefore, I converted it to .txt and attached it.
  
  Thank you very much and please let me know if you need any additional information.

  dhall October 27, 2017 12:08

  - 0 +
• 
  I've got the file (BTW, upload as ZIP should work). The options are dramatically different as I look through them. I don't know that I can get a mapping from options such as 1 to Upper Case for the enums in the old styles today, but I've left a few messages with development to try and sort this out. When I look through your style, I can't quite tell what items to map across.
  
  I'll update as soon as I can.

  way0utwest October 27, 2017 18:00

  - 0 +
• 
  OK, I found a converter tool. Please try this style and let me know if it works.

  way0utwest October 27, 2017 23:34

  - 0 +
• 
  Thank you for the conversion. It still changed some things in our code but I am working on tweaking some settings to keep things as similar as possible.
  
  One area in which I immediately see a discrepancy is regarding comment alignment. We often keep comment blocks (/* */) left-justified, but this version is automatically indenting them. I did not see an option in the style editing to keep comment blocks as is. Do you know if that is an option, or might I have missed it? Thanks again.

  dhall October 31, 2017 14:17

  - 0 +
• 
  Hi @dhall,
  
  Thanks for the suggestion. This isn't currently possible in SQL Prompt 8 but other users have reported it to UserVoice.
  
  Would it be possible to vote for it on UserVoice?
  https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/32113720-preserve-indentation
  
  Best wishes,
  
  Michael
  

  Michael Clark November 03, 2017 13:27

  - 0 +
• 
  Hi Michael,
  
  Thanks for the response and idea suggestion. The ticket you referenced did not fit our situation since it was regarding single-line comments versus multiple-line comment blocks (/* */), and the author mentioned wanting to indent it a certain way whereas we would like an option for no indentation whatsoever.
  
  I did not see exactly what I was looking for within the current ideas; I also tried to use the search functionality but the results were full of many that were Declined or Completed, or were too vague. Therefore, I created a new idea for preserving the format of multiple-line comment blocks.
  
  Unfortunately, our team cannot upgrade to SQL Prompt 8 until this issue is resolved because our product involves tens of thousands of lines of customer-facing SQL code with many multiple-line comment blocks left-aligned for consistency and readability. Additionally, each change we make needs to be justified to our customers, so massive formatting changes are problematic for us.
  
  Thanks again,
  Deb

  dhall November 03, 2017 14:48

  - 0 +
• 

  way0utwest said:

  OK, I found a converter tool. Please try this style and let me know if it works.

  How about supplying the "converter tool" so that others can make use of it?

  DevOpsGSC February 20, 2019 11:39

  - 0 +

Add comment

Please sign in to leave a comment.