Share via

Migration From Physical SQL Server Windows 2012 To Azure

Hadi Burhan 80 Reputation points
2024-10-17T05:17:50.4733333+00:00

Hi All,

I have a On prem physical SQL Server running windows 2012. I have site to site connectivity already establishes. The SQL Server is running ABOUT 30 DB.
Our goal is to completely migrate the DB so we can decommissions the on prem server. I decided to migrate to Azure Database Migration Instance but I have seen the Microsoft have made many changes in the documentation and are using Data Studio which doesn't support windows 2012 as far as I am aware and there is no alternative method provided in the documentation for online and offline migration.

Can anyone recement what to do exactly as i watched a few videos and they used DMA for assessment and for the migration they didn't use anything like the Data studio they just create a DMI and a storage account and an application and just did the migration. The link to that procedure is below but i cant find any documentation related to this procedure
https://www.youtube.com/watch?v=P_4EaqVR5PI&t=717s

Thanks

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,062 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,766 Reputation points
    2024-10-17T09:04:45.43+00:00

    Hi Hadi Burhan •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to migrate SQL Server On premises to Azure.

    However, as per support document Windows Server 2012 is not a supported OS for migration to Azure.

    Azure Migrate now supports in-place upgrades of Windows Server 2012 and later versions, during the move to Azure. Organizations can now elect to move their legacy applications and databases to a fully supported, compatible, and compliant operating system such as Windows Server 2016, 2019, or 2022. Organizations can also avoid downtime by first upgrading to a test environment in Azure and running production workloads in parallel to confirm functionality and compatibility, before fully moving to Azure.

    With this new feature, organizations can avoid Windows Server 2012/R2 end of support and accomplish their modernization and migration goals in one motion. Learn more about this feature in Azure Migrate here.  

    Hope this helps. Let us know if you have any further questions.

    Thanks

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.