Useful for relatively large databases?

May 21, 2013 at 10:25 PM
I'm curious to know if the SQL Database Migration Wizard has been used to transfer databases in the 50 GB to 100 GB range to Azure. If so, how long did the process take?
May 22, 2013 at 3:42 AM
Yes, I have done that, but it took me something like 3 days. I have seen a random error running on Windows Server 2012 which I am still trying to trace down. So, if you hit a random error, let me know. One thing that I am going to do on my next run is up the chunk size. Currently the Chunk size is 500,000 rows. On my next test, I am going to try 10,000,000 record chunk size. Anyway let me know how it goes for you and let me know of any errors you get.