You have an on-premises Microsoft SQL Server instance named SQL1 that hosts multiple databases. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1. You need to…

Question

Options

• AData Migration Assistant (DMA)
• BSQL Server Data Tools (SSDT)
• Ca self-hosted integration runtime
• Dan Azure Migrate appliance

• A
  12% (6)
• B
  4% (2)
• C
  79% (41)
• D
  6% (3)

Explanation

Migrate SQL Server to Azure SQL Managed Instance with DMS You can use Azure Database Migration Service (DMS) and the Azure SQL migration extension in Azure Data Studio to migrate databases from a SQL Server instance to Azure SQL Managed Instance with minimum downtime. Prerequisites include: * Provide an SMB network share, Azure storage account file share, or Azure storage account blob container that contains your full database backup files and subsequent transaction log backup files. Database Migration Service uses the backup location during database migration. * If your database backups are on a network file share, provide a computer on which you can install a self-hosted integration runtime to access and migrate database backups. The migration wizard gives you the download link and authentication keys to download and install your self- hosted integration runtime. * If you use a self-hosted integration runtime, make sure that the computer on which the runtime is installed can connect to the source SQL Server instance and the network file share where backup files are located. https://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/database- migration-service?tabs=offline-with-extension

No community discussion yet for this question.