Command Line Wizard
The built-in Command Line Wizard enables you to convert options into command-line syntax, which can then be saved as a .bat file for scheduling and automating database comparisons and synchronizations.
Open the Command Line Wizard
To open the Command Line Wizard, in SQL Formatter Wizard, click Save Command Line in the lower-left corner.
Command Line Wizard options
The table provides options available in the Command Line Wizard.
| Parameter | Description |
|---|---|
| Connection | Specifies the connection string. |
| Password | Specifies the server password. This value overrides the password specified in the /connection parameter. |
| Profile | Specifies the path to a file that contains formatting option settings, or a predefined profile name. If not specified, the default formatting options are applied. |
| Encoding | Specifies the encoding to use when opening and saving files. |
| Source File | Specifies the source SQL file to be formatted. |
| Output File | Specifies the path to the output file where formatting results are saved. If not specified, the source file is overwritten with the formatted results. |
| Log File | Generates a log file and saves it in the specified folder. |
| Echo OFF | Wraps all text in the .bat file within the @Echo OFF ... Echo ON block. |
| Keep Opened | Adds the pause command at the end of the .bat file. |
| PowerShell | Adds the & symbol at the beginning of the .bat file. |
To save the changes, click Save.
To discard the changes, click Cancel.
Command line validation
To verify the settings, click Validate.
If the syntax is valid, the following message appears:
Otherwise, the corresponding error message appears:
