Program.cs

public class Program
{
	private static void Main(string[] args)
	{
		var host = Host.CreateDefaultBuilder(args).Build();
		
		using var scope = host.Services.CreateScope();

		var logger = scope.ServiceProvider.GetRequiredService<ILogger<Program>>();
		var configuration = scope.ServiceProvider.GetService<IConfiguration>();
		
		const int retries = 10;
		var retry = Policy.Handle<SqlException>()
			.WaitAndRetry(
				retryCount: retries,
				sleepDurationProvider: retryAttempt => TimeSpan.FromSeconds(Math.Pow(2, retryAttempt)),
				onRetry: (exception, timeSpan, attemptRetry, ctx) =>
				{
					logger.LogWarning(exception, "{message} :: [attempt {retry} of {retries}]", 
						exception.Message, 
						attemptRetry, 
						retries);
				});

		retry.Execute(() =>
		{
			/*
			* Your migration routine
			*
			* E.g: yourDbContext.Database.Migrate()
			*/
		});
		
		logger.LogInformation("Database migrations ended without errors.");
	}
}