How to customize formatting styles with profiles

A formatting profile is a saved set of options that help layout SQL code. Data Compare for SQL Server includes two groups of formatting profiles - Devart and Custom. The Devart profiles are the predefined profiles that come with the tool.

The predefined formatting profiles include:

  • Collapsed
  • Commas before
  • Compact
  • Default
  • Extended
  • Indented
  • MSDN SQL
  • Right aligned
  • Stack compact

Set a preferred formatting profile

By default, the active formatting profile in SQL Complete is the built-in Default formatting profile. In order to set a different style from the default one, do the following:

  1. In the Tools menu, click Options.
  2. In the Options window, go to Text Editor > Formatting > Profiles.
  3. Choose one of the predefined formatting profiles.
  4. Click Set as Active.
  5. Click OK.

Modify a preferred formatting profile

Predefined profiles cannot be modified. However, you can use the settings of these profiles as a basis for your own custom profiles. Just do the following:

  1. In the Tools menu, click Options.
  2. In the Options window, go to Text Editor > Formatting > Profiles.
  3. Choose one of the predefined formatting profiles.
  4. Click Open Selected.
  5. Edit formatting options in the left-hand pane.
  6. Click Save As.
  7. Enter a name for your new custom profile.
  8. Click OK.

Create a new formatting profile

  1. In the Tools menu, click Options.
  2. In the Options window, go to Text Editor > Formatting > Profiles.
  3. Click Create New.
  4. Enter a name for your new profile.
  5. Click OK.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?