Hello,

In the Startup.cs file of an ASP.NET Core application, I want to configure the “PreviewOnly” migration mode:

public override void ConfigureServices(IServiceCollection services)
{
   ...
   services.ConfigureRunner(rb => rb.AddSqlServer().AsGlobalPreview(true));
   ...
}

This way I activate the “PreviewOnly” mode and it won't change. However, the mode can change: some migrations can be executed in "dry run" mode, while others can execute the SQL queries on the database, depending on the user's choice.

The aim of “dry run” mode is to provide the user with a list of SQL queries to execute.

How can I configure migration to take into account the change in value of the “PreviewOnly” option?

Information:

OS: Windows 10.0.22631 Build 22631
Platform: .Net Core 8.0.11
FluentMigrator version: 5.2.0
Database Management System: Oracle, PostgreSQL, SQLServer