locked
Migrate from and Azure SQL Server Virtual Machine to an standard Azure VM RRS feed

  • Question

  • I have a an Azure VM which was purchased as an included SQL Server virtual machine.  There is also IIS running with multiple web applications on the same VM.  We want to uninstall SQL server and use MySQL instead.  Is it possible to migrate this Azure "SQL Server" virtual machine to a non-SQL Azure virtual machine?  The reason for this is the price of an Azure VM with SQL is substantially higher than without.  Now that our requirement for SQL is no longer there can I migrate?  Or can I just change the price plan provided I uninstall SQL? Or Can I just image the Azure SQL server VM and transfer the image onto a normal non-SQL Azure VM?  I.e. are the images compatible?

    Thanks in advance

    Kelly

    Friday, November 14, 2014 12:46 AM

Answers

  • Hi Kelly,

    Thanks for posting here.

    For existing database applications, identify which databases you want to migrate to SQL Server in Azure Virtual Machines first. Then, follow one of these two options:

    • Convert physical or virtual machines to Hyper-V VHDs by using System Center 2012 Virtual Machine Manager a physical-to-virtual machine (P2V) or a virtual-to-virtual (V2V) wizard. Upload VHD files to Azure Storage by using the Add-AzureVHD cmdlet. You can then deploy a new virtual machine by using the uploaded VHD. You can manage, upgrade, and monitor your database by using the traditional administrative tools, such as SQL Server Management Studio.
    • Provision a new Virtual Machine with the SQL Server platform image as well as an application-tier cloud compute resources at the Azure Management Portal. Create a database deployment package by using SQL Server Data Tools and SQL Server Management Studio. Migrate the existing application-tier to Azure Project by using Azure SDK and plugins for Visual Studio, Java, PHP, or Node.js. Deploy an application-tier to Azure and access your data on the cloud.

    I suggest you to follow these links for more details.

    http://msdn.microsoft.com/en-us/library/azure/jj156165.aspx

    http://msdn.microsoft.com/en-us/library/azure/dn727124.aspx

    Also, I see a similar thread opened by you on SQL Server Migration.

    https://social.msdn.microsoft.com/Forums/en-US/4852daee-aa4f-4341-9a5a-2b4612e39378/migrate-from-sql-server-virtual-machine-to-normal-one?forum=WAVirtualMachinesforWindows

    Request to follow both the instructions as mentioned.

    Hope this helps you.

    Girish Prajwal

    • Proposed as answer by Girish Prajwal Friday, November 14, 2014 5:20 AM
    • Marked as answer by Girish Prajwal Tuesday, November 18, 2014 12:19 AM
    Friday, November 14, 2014 5:05 AM