Working with Heroku Connect means that at some point some records will end up in a failed state. This post shows a few options how to trigger the sync manually again.

An example Nix snippet which provides the Salesforce migration tool inside of a shell environment based on the Nix package manager.

How to migrate custom fields with the Salesforce Migration Tool avoiding failures due to unknown permissions.