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?

| improve this question | | | | |
  • Offtopic. Not really a programming question. Try the DBA site. – Marc B Feb 23 '16 at 14:47

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.

| improve this answer | | | | |
  • first of all, LOL on your first sentences, was felt that ways well, thanks for the solution, but in fact we dont required its run nightly basis, just one time work will do as they are not paid us anymore. – Worgon Feb 24 '16 at 1:10
  • Then use azure migration assistant. It will work for you. – Kin Shah Feb 24 '16 at 1:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.