Tell me please, what is the best way to migrate databases from MS SQL 2008 R2 to SQL Azure (schema and data)? I use a utility http://sqlazuremw.codeplex.com/, but when it starts there is an error "Index was outside the bounds of the array"
There is also a very nice (but discontinued) free tool from Red-Gate:
SQL Azure Backup. The last time I used it was about 2 months ago. I used it to copy databases from SQL Server 2005 and 2008 R2 to Azure and vice-versa. There is also a command-line version!
Hope this helps!
Cheers, Carlos Sardo
Proposed As Answer byCarlos SardoMonday, July 30, 2012 11:32 AM