Introduction to Azure Database Migration Service - SQL on the edge episode 19
Azure has a rich set of offerings in terms of database platform services. We have the full family of SQL Server-based databases (single, pool, managed instance, data warehouse), open source first-party Database-as-a-Service for MySQL, MariaDb and PostgreSQL and the NoSQL Cosmos DB. One gap that still existed, though, was the lack of an integrated tool to migrate your on-premises databases to any of these services. There are many ways to do it, of course, but none that were easy to implement and cloud-native. This is where Azure Database Migration Service (ADMS) comes in. The service is not just for migrating SQL Server to Azure, as some folks might think. It also has support for migrating open-source workloads, as well as Oracle workloads, into the services offered by Azure. Say you are migrating Oracle data to PostgreSQL. Well, you can actually do this with ADMS! And because it is a managed service, you don't have to worry about managing infrastructure, monitoring or the actual mechanics of the data movement. And because it's a cloud service, once your migration is complete, you can simply stop using the service and stop getting billed.
Service ModelThe service currently offers two tiers:
- Standard: 1-2-4 cores, allows for offline migrations, free
- Premium: 4 cores, allows for online migrations, charged per hour (first 6 months free)