# Operational Scripting


In order to generate database scripts outside of a build process, use the `NServiceBus.Persistence.Sql.CommandLine` command prompt tool developed for this purpose.

The tool can be downloaded from NuGet and installed using the following command:

```
dotnet tool install -g NServiceBus.Persistence.Sql.CommandLine
```

Once installed, the `sql-persistence` command line tool will be available for use.

`sql-persistence <command> [options]`

### Available commands
This tool currently has one command.
- `script`

### sql-persistence script

Generates scripts required to setup a database for an NServiceBus endpoint:

```
sql-persistence script <assembly>
                              [--output-dir]
                              [--clean]
                              [--overwrite]
                              [--dialect]
                              [--verbose]
```

#### Options
 
`-o=<path>` | `--output-dir=<path>` : Path to the output directory. If not specified, the current directory will be used.

`--clean` : Removes existing files in the output directory

`--overwrite`: Overwrites existing files in the output if they match the files to be generated

`--dialect=<value>`: Specifies a dialect to generate. Allowed values are: SqlServer, MySql, Oracle, PostgreSql

`--verbose`: Verbose logging