From the course: Implementing a Data Warehouse SQL Server 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

The Data Warehouse Migration Utility

The Data Warehouse Migration Utility - SQL Server Tutorial

From the course: Implementing a Data Warehouse SQL Server 2019

Start my 1-month free trial

The Data Warehouse Migration Utility

“

- [Instructor] If you currently have a data warehouse on an on-premises instance of SQL Server and you'd like to migrate it to the cloud-hosted Azure SQL Data Warehouse then you have a couple of options. The most reliable way is going to involve rebuilding the schema in the Azure database and then move all of your data using a bulk copy or a custom extract transform and load procedure. Depending on the size and complexity of your data warehouse you might be able to use a tool called the Data Warehouse Migration Utility to help you out with some of the work. You can find the tool at the Microsoft download page at this URL. You can see that the tool is currently still in preview, so you'll definitely want to test it out thoroughly in your own environment before relying on it to migrate your own on-premises data warehouse. But let's run through an example and you can see how it works. I'll click the Download button to download…

Contents