Data Migration to Azure Table Storage

Question

Are there any tools or easy methods for migrating data from a local relational database to Azure table storage?  I have around 20GB of data in a table that I would like to move to azure table storage.  I know row keys and partition keys will need to be generated, but wanted to see if there is a generic tool that can assist with the migration, or if I need to start building something custom.  

Thanks in advance,

Cory

 

Answer 1

Hi Cory,

May I suggest you take a look at our tool Cloud Storage Studio . It has a utility using which you can import data from a SQL Server / MySQL database into Azure Table Storage. Here is the blog post which describes this utility in greater detail: http://www.cerebrata.com/Blog/post/Upload-Relational-Data-In-Azure-Table-Storage-Using-Cloud-Storage-Studio.aspx

Hope this helps.

Thanks

Gaurav Mantri

Cerebrata Software

http://www.cerebrata.com

Answer 2

Thanks!  Just downloaded it and it plugged right into my development storage.  We're a bit away from a production deployment, but will definitely look into purchasing a license to assist that migration when the time comes.

 

-Cory

Answer 3

Hi Cory - Any specific reason you want to stick to table storage? With the magnitude of data you are talking about.. why not try SQL Azure? Is "cost" the only factor you are moving away from SQL Azure?