'Replication' solution from sql server to sql dataware house?
Why not implement a Sql server 'Replication' solution from sql server (on premise / Azure) to sql dataware house (on Azure)?
It would be useful if we have a processing DB in sql server and a accumulating datawarehouse in sql datawarehouse, with not too many structural changes.
Thank you for voting on this feature. Please describe your scenario in the thread below. We currently have many migration solutions from SQL Server to SQL Data Warehouse such as Azure Data Factory and Redgate through the Quick Load Azure portal experience (link below). If this is a continuous replication process, we’d love to understand your hybrid scenario so please comment below.
amr salah commented
Enable some seamless replication between on premise database to Azure data warehouse , this can be using replication , log shipping , mirroring or some sync Agent deployed on premise . Using SSIS packages to sync huge databases takes a lot of work and wouldn't be as robust .
Morgan Clark commented
This would be a great feature for my company, too, as we have data in on-prem SQL Servers that will need to make it up to Azure DW. If we could simplify getting it there by using replication, log shipping, mirroring, some kind of change data capture, etc, it would be fantastic! Seems like an awful lot of work to have to bcp out, ship to blob/polybase, attach, then insert from there...