README.md

AzureTableStorageCopier

Some sweet code that will copy tables from one Azure Table storage to another Table Storage or to Azure SQL database.

If you want to learn more visit

How to run?

1. Create a source Azure Storage account and add a table with the structure as per file 001_CreateUserType.sql. Remember that order of the columns matters, it seems like it's identical to Azure Storate Explorer order: Partition Key + RowKey + Timestamp + other columns alphabetically.
2. Create a target storage account OR Azure SQL database (it depends what scenario you want to run, there are two console apps in this solution)
3. Create an application in Azure Active Directory - add applicationId and authenticationKey to appsettings.json
4. Configure other properties in appsettings.json (if you want to migrate to SQL, remember about appsettings.json in DbUp project)
5. If you migrate to SQL run DbUp project

If you don't want to use stored procedure and you would prefer SQL tables to autocreate, Schema and Table properties in AzureSqlTableDataset are mandatory.

new AzureSqlTableDataset
{
    LinkedServiceName = new LinkedServiceReference
    {
        ReferenceName = sqlDatabaseLinkedServiceName
    },
    Schema = "dbo",
    Table = tableName
}

Contains

• .NETCore 3.1
• Microsoft.Azure.Management.DataFactory 4.8.0
• Microsoft.Azure.Management.ResourceManager 3.4.0-preview

Learn more

• https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server
• https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-table-storage

License

MIT