Migrating from amazon SimpleDB to SQL Server

Question

I've got an interesting problem. I recently started working at a new company that's using Amazon SimpleDB and amazon S3 to do all their storage. Having large domains is killing their performance. Instead of splitting up domains, they want to go to an SQL solution (Microsoft azure). What would be the easiest way of migrating to this?

Keep in mind, The datatypes from Amazon's SimpleDB are being used internally in the program, so simply exporting each domain's data as string to an sql table would be ok to start with.

That being said, how would I go about doing that?

Answer 1

There is a web based tool called BackupSDB that claims to backup SimpleDB domains to XML files and then store them on S3. You should be able to download the XML and then import it into SQL with your preferred ETL tool...

I've never tried BackupSDB personally, so this is purely theoretical... :-)