If you believe my posts will help someone please feel free to share.

Updating text formats in Drupal 8 via database.

During my migration from Drupal 7 to Drupal 8, I relieved an error regarding updating text filter formats so I decided to do it post migration.

To see all columns that need updating

You can use this information to run queries like below.

For nodes

For comments