Page 1 of 1

dbForge SQL Formatter - RedGate Profile

Posted: Tue 18 Oct 2022 09:33
by 5vmek23f
By any chance has anyone created a SQL Formatter Profile to match the RedGate SQL Formatter style?

If so, can you share it, please?

Re: dbForge SQL Formatter - RedGate Profile

Posted: Tue 18 Oct 2022 09:47
by 5vmek23f
Also, does anyone know the setting to have a new line after AND ( ?

Formatting this:

Code: Select all

WHERE a.AddressLine1 IS NOT NULL
    AND a.AddressLine2 IS NOT NULL
    AND (a.PostalCode IS NOT NULL
        OR a.PostalCode IS NOT NULL)
    AND e.JobTitle IS NULL
To this:

Code: Select all

WHERE a.AddressLine1 IS NOT NULL
      AND a.AddressLine2 IS NOT NULL
      AND (
              a.PostalCode IS NOT NULL
              OR a.PostalCode IS NOT NULL
          )
      AND e.JobTitle IS NULL

Re: dbForge SQL Formatter - RedGate Profile

Posted: Wed 19 Oct 2022 07:56
by dzhanhira
Kindly be informed that it is not possible to configure, you can do something similar:

https://drive.google.com/file/d/11I-kAM ... sp=sharing