1) Try setting "Do not user checksum for comparing files" flag to see if that helps.
2) If you deploy to Azure App Service environment that you can try using slots. They will have different publishing profiles (URLs, credentials, etc.), so you can publish to staging then swap it with production and so on. AppVeyor doesn't provide built-in support for slots, but you can use az CLI to to that.