none
Export Azure Table to SQL Server/Azure

    Question

  • Is there a tool that I can use to export data out of Azure Table Storage to SQL Server/Azure?
    Tuesday, February 2, 2016 9:13 PM

All replies

  • Saleem, 

    AZ Copy tool supports exporting Azure Table entities in various formats but not directly into SQL Azure.

    You can refer to AZ Copy Article on how to use it to export data in different formats from Azure Table Storage.

    Wednesday, February 3, 2016 1:35 AM
  • have a look at Azure Data Factory.
    Wednesday, February 3, 2016 6:20 AM
  • Another option would be to write some custom code for this, which should be quite easy.
    There's SDK's which make it a breeze both for retrieving objects from Azure Tables as well as pushing them to SQL / Azure SQL.
    https://azure.microsoft.com/nl-nl/documentation/articles/storage-dotnet-how-to-use-tables/

    Another option could be SSIS.
    https://visualstudiogallery.msdn.microsoft.com/6578b2f9-adb1-4bf2-8d50-f62d47403829

    Wednesday, February 3, 2016 7:24 PM