0

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?

asked Feb 23, 2016 at 14:45
1
  • Offtopic. Not really a programming question. Try the DBA site. Commented Feb 23, 2016 at 14:47

1 Answer 1

1

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.

answered Feb 23, 2016 at 17:53
2
  • 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. Commented Feb 24, 2016 at 1:10
  • Then use azure migration assistant. It will work for you. Commented Feb 24, 2016 at 1:25

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.