Which is the best way to migrate my SQL table to Table Storage?

From Prashant @prashan76643858 via Twitter:

 I need to migrate my sql table (huge) to table storage. It is a single table with around 1 billion records, and we were hoping to complete migration in maximum 15 hours. Do you have any suggestions/recommendations?

https://twitter.com/prashan76643858/status/638578028704956416

Thanks,

@AzureSupport

September 2nd, 2015 7:15am

Hi Prashant,

I see that, mysql table can be exported as xml. Upload that XML to blob storage and write worker role/code that pulls the XML from blob storage, parses it, and writes it to tables.

Hope this helps you.

Girish Prajwal

Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 11:58am

Hi Prasanth,

In addition to what Girish told, please check out the tool called AzCopy. 

For more information : https://azure.microsoft.com/en-in/documentation/articles/storage-use-azcopy/

If its feasible, you can write an migration script to automate the migration. 

September 3rd, 2015 1:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics