Mittwoch, 22. September 2010 15:49
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,
- Verschoben Brian AurichMicrosoft Employee, Moderator Mittwoch, 29. September 2010 04:25 migration (From:Windows Azure - Archive)
Mittwoch, 22. September 2010 16:21
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.
- Als Antwort markiert Brad CalderModerator Sonntag, 27. März 2011 00:58
Mittwoch, 22. September 2010 16:41
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.
Mittwoch, 22. September 2010 17:12Hi 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?