Migrate On-Premise SQL Server Data Warehouse to Azure Cloud with 100% compatibility

Cloud has become the primary location for Organizations to store their data and many of the Organizations are already in the process of migrating their on-premise data to the cloud. The key factors for organizations to move data to the cloud are to strengthen the security and the shift from legacy to modern data platforms.

In this post, we will see how we can Migrate an on-premises SQL Server Data Warehouse to an Azure SQL Managed Instance

Azure SQL Database Managed Instance is a powerful and economical cloud destination for companies to migrate their on-premises SQL Server databases (size up to 35 TB).

The below illustration shows the steps involved in the Database Cloud Migration

Backup the on-premises database

1.Connect to the SQL Server instance from the SSMS
2.Expand the Databases and select the database that you wish to backup.
3.Right-click the database → Tasks and then click Back Up
4.In the Backup type drop-down list, select the Full.
5.In the Destination section, review the default location for the backup file (in the ../MSSQL/Backup/).
6.Click OK to initiate the backup.
7.When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.