I've added a DbSync API call that implements EFCore 6 (specifically 6.0.36).

Within the API call the migration is called simply with this line

await dbContext.Database.MigrateAsync();

One of the changes that are being applied in this migration is changing the precision and scale of a large amount of columns, as I expected there is some data that exceeds the new precision. And hence this error is thrown.

"Arithmetic overflow error converting numeric to data type numeric"

When the error is thrown and the statement is terminated I want to log what column in what table caused the issue, so that the admin that is running the migration can go and manually fix the data.

Thanks in advance for any assistance.