You can restore SQL databases from an on-premises SQL server to an Azure cloud.
The destination instance must be the same version or a later version of SQL than the source instance.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances page, in the row for the on-premises SQL server instance, click the action button
, and then click Restore.The Backup content dialog box appears.
-
Select the content to restore, and then click Restore.
The Restore options dialog box appears.
-
Select Out of place.
-
From the Restore type list, select Cross instance restore.
-
From the Destination server list, select the database server that has SQL server instance.
-
From the Destination instance list, select the on-premise SQL server to which you want to restore the data.
-
From the Access node list, select the access node.
-
In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.
Verify that you have sufficient space in the staging path for the restore operation.
-
If you want to rename the database, in the Data Files section, type the new name for the database.
If you change the name of the database to a name of a database that already exists on the destination instance, the database will be overwritten.
-
To specify the database pricing tier, in the Advanced Options section, select the Database Tier for the database.
If you don't select a database pricing tier, the default Pricing Tier Standard S0 will be applied by default.
-
Click Submit.