Deploy Database from Azure SQL Database to Azure VM SQL Database

 

In this post we will go-over on how to move the Azure SQL Database to Azure VM SQL Database. You cannot backup the the Azure SQL Database by issuing Backup Database  Command on version

[Microsoft SQL Azure (RTM) – 11.0.9230.80  Mar 10 2015 12:37:14      Copyright (c) Microsoft Corporation]

it will prompt the below error

Msg 40510, Level 16, State 1, Line 1
Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.

To quickly deploy the database from Azure SQL Database Server to Azure VM SQL Database Server i used [Deploy SQL Database to Windows Azure Database] Wizard from On-Premises SQL Server Management Studio. (Note:  If the firewall rules are not opened to connect to Source and destination from On-premises firewall  the wizard will fail to connect and deploy)

 

image

 

Leave a Reply

Your email address will not be published. Required fields are marked *