locked
Need to get solution on Azure RRS feed

  • General discussion

  • Hi MS team,

    1. Currently, my company use SQL data warehouse on-premise for reporting. Data source is ingested and store into SQL server in itegration staging (on the same physical server) and then data is analyzed into Star schema in SQL server via store procedures (n the same physical server). The problem that is I want to modern data warehouse system to get better performance. So I want to use new architecture: Data source is ingested into Azure Data lake and them ELT into Azure SQL DW and move out analytics out of store procedure and use other tool OLAP in Azure. So This is correct approach?

    1. If this is correct approach. So how to I migrate data from current SQL DW to Azure SQL DW with no downtime. Please suggest me a plan for that.

    Thank you,

    Dzung Dinh

    Saturday, September 5, 2020 10:35 AM