# PublishAsMigrationScript

- Module: [Aspire.Hosting.EntityFrameworkCore](/reference/api/go/aspire.hosting.entityframeworkcore.md)
- Version: `17.0.0-preview.1.26565.2`
- Kind: `method`
- Defined on: [`EFMigrationResource`](/reference/api/go/aspire.hosting.entityframeworkcore/efmigrationresource.md)
- Source: [GitHub](https://github.com/microsoft/aspire/tree/bcfa151cdca6d0a573f22d5d9c23f9c727cb3b2f)

Configures the EF migration resource to generate a migration script during publishing.

## Remarks

During `aspire publish`, the generated SQL script is written to the publish output directory under
the `efmigrations` folder. The script is included as a deployment artifact, but it is not executed
automatically during deployment.

## Definition

```go
func (EFMigrationResource) PublishAsMigrationScript(options ...*PublishAsMigrationScriptOptions) EFMigrationResource
```

## Parameters

- `options` (`...*PublishAsMigrationScriptOptions`) -- optional settings, see [Options](#options)

## Options

Optional parameters are passed in a trailing `options ...*PublishAsMigrationScriptOptions` argument.

- `Idempotent` (`*bool`) -- If `true` (the default), generates an idempotent script with `IF NOT EXISTS` checks so it can be safely re-run against a database that has already had some or all of the migrations applied.
- `NoTransactions` (`*bool`) -- If `true`, omits transaction statements from the script.

## Returns

[`EFMigrationResource`](/reference/api/go/aspire.hosting.entityframeworkcore/efmigrationresource.md) -- The resource builder for chaining.

Returns a handle; failures surface later via `Err()`.

## Applies to

- [`EFMigrationResource`](/reference/api/go/aspire.hosting.entityframeworkcore/efmigrationresource.md)
