locked
Data Migration to Azure Table Storage RRS feed

  • 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

     

    Wednesday, September 22, 2010 3:49 PM

Answers

All replies

  • 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

    • Marked as answer by Brad Calder Sunday, March 27, 2011 12:58 AM
    Wednesday, September 22, 2010 4:21 PM
  • 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

    Wednesday, September 22, 2010 4:41 PM
  • 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? 
    Wednesday, September 22, 2010 5:12 PM