One of my customers stopped subscribing to our services and they INSIST to have their data stored in their local SQL Server. Their data size is quite some amount though.
We did try to use the Azure Sync (Preview) and the process is painful and troublesome.
Question came in mind, is there a traditional way that backup to .bak and restore to their SQL Server? Is there any other way of doing this?
Best Answer
I would ditch Azure Sync by all means .. buggy and still in preview since ages.
We have exactly same requirement and what I did was create SSIS package and load the data from Azure to OnPremise on a nightly basis. It works just fine once you set it up. Make sure to load the data as per FK relationship.
On other side, you can explore Windows Azure SQL Database Import/Export Service.