db-patch

Generates migration SQL patch files and corresponding rollback files for any pending schema changes.

Usage

dotnet run -- db-patch <filename>

Example:

dotnet run -- db-patch migrations/patch001.sql

This generates two files:

• migrations/patch001.sql -- the forward migration SQL.
• migrations/patch001.drop -- the rollback SQL to undo the migration.

Options

Option	Description
--transactional-script	Wrap the generated SQL in a transaction
--auto-create	Override the AutoCreate behavior (default: CreateOrUpdate)

When to Use

Use db-patch when you need to:

• Have a DBA review migration SQL before it runs against production.
• Store migrations in version control alongside application code.
• Apply migrations through a separate deployment tool or process.
• Audit what changes will be made before applying them.

Legacy Name

In Marten versions prior to V5.0, this command was called marten-patch.