« Previous 1 2 3
SQL Server 2022 and Azure
Cloud Power
Database Licensing and Migration
The databases in Azure can be run in parallel with on-premises databases and in parallel with other services in Azure. Migration and synchronization are possible in all directions. Additionally, Microsoft tools support migration. In parallel, Microsoft offers the Azure Hybrid Advantage for Microsoft SQL Server, which means that local Microsoft SQL Server licenses can also be used in the cloud.
The Data Migration Assistant (DMA) [6] is a Microsoft tool that can help admins migrate SQL databases from end-of-life servers. DMA can also be used to migrate on-premises databases to Microsoft Azure. However, Microsoft recommends the use of the Azure Database Migration Service [7] instead.
Conclusions
SQL Server 2022 is more closely tied in with Azure than any previous version, especially in the areas of availability and data analytics. Comprehensive support for Azure SQL Managed Instances and Azure Synapse means that even larger volumes of data can be analyzed quickly and effectively. Migrating from previous versions to SQL Server 2022 is very much recommended for enterprises looking to rely more heavily on Azure with a view to improving server availability or analyzing data with various Azure services. Of course, the new version also offers better performance, as is the case with any new SQL Server version.
Infos
- Azure Hybrid Advantage for SQL Server: https://azure.microsoft.com/en-us/pricing/hybrid-benefit/
- Database Migration Service: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance#create-an-azure-database-migration-service-instance
- Azure Synapse Analytics YouTube video: https://www.youtube.com/watch?v=tMYOi5E14eU
- Azure Data Share: https://azure.microsoft.com/en-us/services/data-share/
- Open Data Initiative: https://docs.microsoft.com/en-us/microsoft-adobe-product-integrations/
- Data Migration Assistant: https://www.microsoft.com/en-us/download/details.aspx?id=53595
- Azure Database Migration Service: https://azure.microsoft.com/en-us/services/database-migration/
« Previous 1 2 3
Buy this article as PDF
(incl. VAT)
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
-
The Azure Arc multicloud and on-premises management platform
The Azure Arc cloud service supports centralized management of Windows and Linux servers, Kubernetes clusters, and SQL servers that are not themselves running in Azure, extending Azure management capabilities to servers in traditional data centers or any other cloud environment. We show you how to get Azure Arc up and running and look at its key features. -
Migrating to Azure Monitor Agent
The replacement for the Log Analytics Agent has improved security and cost efficiency, better manageability, and greater reliability – and you must migrate to this new solution by the end of 2024. -
Azure AD and AD Domain Services for SMEs
Azure Active Directory Domain Services is a Microsoft product, distinct from Active Directory and Azure Active Directory, that offers centralized directory services in the cloud in place of an often convoluted on-premises operation. -
Server update with Azure Update Management
Microsoft Azure Update Management automatically patches servers in on-premises data centers, virtual servers on Azure and other cloud services, and even Linux servers. -
Private cloud with Microsoft Azure Stack
Azure Stack is an Azure extension that implements an on-premises data center for consistent hybrid cloud deployments.