How to migrate from Azure Table storage to SQL Azure?

1
votes

We use Azure Table storage in our project and we want to migrate to SQL Azure. Is there any simpler way to migrate ?

1
azureazure-sql-databaseazure-storage
"Simpler" way? Compared to what? There's not necessarily a simple answer to this especially because you're shifting from a key/value store to a relational store, with very different schema characteristics. – David Makogon

1 Answers

4
votes

The simple way to move data from Azure Table Storage to SQL Azure is using Azure Data Factory. You can refer to the tutorials Build your first Azure data factory using Azure Portal/Data Factory Editor & Move data to and from Azure Table using Azure Data Factory to know how to do it.