Heroku's database transfer hasn't been super reliable for us recently. I reached out to Heroku and they suggested to me to use the new way of doing that, which is a new (at least different) API from what we were using. I'll be looking into fix this. If anyone has already done this or has insights, feel free to ping me. Otherwise this should be fixed or worked around soon-ish.
It turns out that the other API isn't working most of the time, it initiates a transfer, but they are never done in most cases. I already got a ticket opened at Heroku for this.
Heroku's database transfer hasn't been super reliable for us recently. I reached out to Heroku and they suggested to me to use the new way of doing that, which is a new (at least different) API from what we were using. I'll be looking into fix this. If anyone has already done this or has insights, feel free to ping me. Otherwise this should be fixed or worked around soon-ish.