I have two Azure SQL Database, prod and dev.
How can i daily replicate the prod
database into dev
database?
I have tried to automate it by exporting and importing the BACPAC
file but it takes too long time.
There is Data Sync service in Azure but I am not sure if it works in one direction.
Do you have any suggestions?