Migrate to Azure SQL database using Azure DMS
For more details about the service please follow the link https://azure.microsoft.com/services/database-migration/
The above template will deploy a resource group with the below resources in your subscription.
- An Azure Database Migration Service
- A Windows 2016 server VM with SQL server installed with a pre-created database on the server.
- A Target Azure SQL database server with pre-created schema of the source database on the target server.
- A virtual network to which the source and DMS service will be connected.
Using the above resources you can connect to source and target servers, select the databases to migrate and run an end-to-end migration.
Tags: Microsoft.Compute/virtualMachines, extensions, SqlIaaSAgent, CustomScriptExtension, Microsoft.DataMigration/services, projects, Microsoft.Network/networkInterfaces, Microsoft.Network/networkSecurityGroups, Microsoft.Network/publicIPAddresses, Microsoft.Network/virtualNetworks, subnets, Microsoft.Storage/storageAccounts, Microsoft.Sql/servers, databases, firewallrules