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

Answers

  • 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

    Wednesday, September 2, 2015 3:56 PM
    Moderator

All replies

  • 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

    Wednesday, September 2, 2015 3:56 PM
    Moderator
  • 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. 


    Vishnu VG

    Thursday, September 3, 2015 5:51 PM