Migrating your On Premise database to Azure SQL Data Warehouse
Speaker: Erwin de Kreuk
Duration: 1 hour
Have you ever tried to migrate your On Premise DataWareHouse (DataVault) solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution.
What are the best practices to Migrate your solution with as little impact to users as possible? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience.
I will take you in this session through all the steps you have to take care off. The following points will be discussed Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.