dbForge SQL Formatter - RedGate Profile

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
5vmek23f
Posts: 2
Joined: Tue 18 Oct 2022 09:31

dbForge SQL Formatter - RedGate Profile

Post by 5vmek23f » Tue 18 Oct 2022 09:33

By any chance has anyone created a SQL Formatter Profile to match the RedGate SQL Formatter style?

If so, can you share it, please?

5vmek23f
Posts: 2
Joined: Tue 18 Oct 2022 09:31

Re: dbForge SQL Formatter - RedGate Profile

Post by 5vmek23f » Tue 18 Oct 2022 09:47

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

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: dbForge SQL Formatter - RedGate Profile

Post by dzhanhira » Wed 19 Oct 2022 07:56

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

Post Reply