I have a question around data refresh between PAAS instances.
We currently run a couple of different "Environments" for a few of PAAS SQL databases. Pretty standard development process I would imagine: DEV, UAT and Production. I want to be able to refresh database downward periodically from Production to UAT/Dev. Currently I'm using bacpac's but its very time consuming. I'm just wondering if any other have similar experiences with this? We use a IAAS box in Azure as the location for the bacpac and do all the work from within that server as it has connectivity to all environments.
Our DB's are all S3 at present.
Any one have any thoughts on other methods? Possibly the copy operation from the portal or the migration tool?
Open to suggestions
Many thanks in advance for any help.