gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertDeze browser wordt niet meer ondersteund.
Upgrade naar Microsoft Edge om te profiteren van de nieuwste functies, beveiligingsupdates en technische ondersteuning.
Microsoft provides a suite of tools and services to assist users with migrating various source databases to different target environments.
This article briefly overviews the tools available to migrate to SQL Server and Azure SQL.
Azure Database Migration Service enables seamless migrations from SQL Server database sources to Azure SQL offerings with minimal downtime. The Database Migration Service provides a resilient and reliable migration pipeline that requires minimal user involvement during the overall migration process.
With Azure Database Migration Service currently we offer two versions:
Use the latest Azure Database Migration Service in the following scenarios:
Notitie
DMS(classic) - SQL scenario are on the deprecation path. Refer here
For more information, visit Azure Database Migration Service documentation.
Azure Migrate provides a centralized hub to discover and assess on-premises servers, infrastructure, applications, and data to Azure at scale. Azure Migrate offers a unified migration across your servers, databases, and applications.
Use Azure Migrate to discover all your SQL Server instances across your datacenter, assess application dependencies, understand the readiness of these SQL Server instances migrating to Azure SQL, and get Microsoft recommendations, such as the optimal Azure SQL deployment option and the correct SKU that can fit the performance needs for your workloads. You can also get the monthly estimates running these databases on Azure SQL to cater to your licensing benefits.
Use Azure Migrate in the following scenarios:
For more information, visit Azure Migrate documentation.
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.
Use DMA in the following scenarios:
For more information, visit Data Migration Assistant documentation.
SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration to SQL Server and Azure SQL from alternative database engines.
Use SSMA in the following scenario:
For more information, visit SQL Server Migration Assistant documentation.
Use the following chart to compare capabilities of the SQL migration tools:
Capability | Azure Migrate | DMA | SSMA | DMS(classic) | Azure Data Studio extension (DMS) |
---|---|---|---|---|---|
Discover and assess SQL data estate | At scale | Yes | No | No | Yes |
Migrate SQL Server objects to SQL Database or SQL Managed Instance | No | Yes | No | NA (deprecated) | Yes |
Lift and shift SQL Server to SQL Server on Azure VM | Yes | No | No | No | No |
Migrate (and/or upgrade) SQL Server to SQL Server on Azure VM | No | Yes | No | No | Yes (Migrate only) |
Migrate non-SQL objects (Oracle, Access, DB2, and so on) |
No | No | Yes | No | No |
Migrate open source databases (MySQL, PostgreSQL, MariaDB, and so on) |
No | No | No | Yes | No |
gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertTraining
Module
SQL Server-databases evalueren voor migratie naar Azure SQL - Training
Meer informatie over meerdere evaluatiehulpprogramma's die de migratie van databases naar Azure vergemakkelijken, waaronder de Azure SQL Migration-extensie voor Azure Data Studio, Azure Migrate en Data Migration Assistant.
Certificering
Microsoft Certified: Azure Database Administrator Associate - Certifications
Beheer een SQL Server-databaseinfrastructuur voor cloud-, on-premises en hybride relationele databases met behulp van de relationele Microsoft PaaS-databaseaanbiedingen.
Documentatie
Data Migration Assistant uitvoeren vanaf de opdrachtregel - SQL Server
Leer hoe u Data Migration Assistant via de commandoregel uitvoert om SQL Server-databases te evalueren voor migratie.
Een SQL Server-migratiebeoordeling uitvoeren - Data Migration Assistant
Meer informatie over het gebruik van Data Migration Assistant om een on-premises SQL Server te evalueren voordat u migreert naar een andere SQL Server of naar Azure SQL Database
Aanbevolen procedures voor Data Migration Assistant - SQL Server
Meer informatie over aanbevolen procedures voor het migreren van SQL Server-databases met Data Migration Assistant, inclusief informatie over installatie, evaluatie en migratie.