DevOps newbie scenario and questions:
There are two teams of Developers/ Testers in NZ and the UK who regularly check in SSDT code using on premise TFS 2013 on NZ server. Issue is the number of merge conflict, slow gets, slow checkins, builds and deployments to the UK from NZ. Looking to upgrade SQL to 2016 on the TFS server in NZ, upgrade to TFS 2018 (latest SP) and then migrate to the cloud in a pre-prod environment and test.
However noted that due to the large SSDT solutions, I will require on premise private agents in NZ and the UK, which then begs the question if a TFS Admins is logging onto VS in NZ but deploying to London, would the agent used be the London Agent or the NZ agent? If the Agent used in on prem NZ I suspect it won't be much faster to deploy in the UK.
Alternatively If I set up a TFS proxy server in London and upgrade the disks to SSD and up the vCPU's how would this work on the TFS Proxy server in London, i.e. can I deploy the solution in an on premise set up from the proxy server in the UK? Or does the deployment have to be from the main TFS server in NZ?