Data Migration to Azure Table Storage
-
2010年9月22日 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,
Cory
- 移動 Brian AurichMicrosoft Employee, Moderator 2010年9月29日 4:25 migration (From:Windows Azure - Archive)
すべての返信
-
2010年9月22日 16:21
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
- 回答としてマーク Brad CalderModerator 2011年3月27日 0:58
-
2010年9月22日 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.
-Cory
-
2010年9月22日 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?

