I actually solved this with our custom deploy script. We choose the machine that runs the migrations. The necessity of building and maintaining a custom deploy

I actually solved this with our custom deploy script. We choose the machine that runs the migrations. The necessity of building and maintaining a custom deploy script is the biggest wart for us (though I admit that the API is pretty good, and said script has not had that much maintenance overhead).