Migrating homogeneous and heterogeneous databases to Azure SQL Database

Migrating homogeneous and heterogeneous databases to Azure SQL Database

In this tutorial, we will look at how we can use the Azure Database Migration Service to migrate to Azure SQL Database

In this article, we will look at how we can use the Azure Database Migration Service to migrate to Azure SQL Database.

Introduction

Databases come in different varieties like relational, document, NoSQL databases, etc. Some of these databases are commercial and some are open-source. Enterprises host data on-premises as well as in the cloud. In a scenario where one has a large data landscape and a variety of options, it’s very obvious that there would be situations where one would want to migrate data from one database to another to exploit the specific features offered by any given database on any given hosting environment. Due to the varying types of databases, database migration can be categorized into two types – homogeneous and heterogeneous.

When the source and target database for data migration are of the identical nature or similar category, for example, relational databases or say SQL server on-premises to Azure SQL Database on Azure cloud, it can be termed as homogeneous database migration. When the source and target database for data migration are of different categories, for example, MongoDB to Azure SQL Data, it can be termed as heterogeneous data migration. Azure offers different tools like SQL Server Migration Assistant, Data Migration Assistant, and Database Experimentation Assistant to assess both types of database and data migration. Once the assessment is complete, the Azure Database Migration Service is used to carry out actual data migration for schema as well as data. In this article, we will learn how to use this service with a focus on migrating to SQL Database on Azure.

Creating Azure Database Migration Service Instance

It is assumed that one already has an Azure account with privileges to operate and administer the database migration service. Assuming that the assessment phase is already completed, and we are into the actual implementation phase where we need to start migrating the schema or data, the first step is to create an Azure Database Migration Service instance. For now, let’s assume that we intend to migrate AWS RDS SQL Server to Azure SQL Database or data from an on-premises SQL Server to SQL Database on Azure.

Navigate to the Database Migration Service on Azure to reach the dashboard page as shown below. This is the point where we can create a new instance.

azure sql azure azure sql

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

Demo: Configure Azure SQL with Azure CLI | Azure SQL for beginners (Ep. 17)

In this video, see how to configure your Azure SQL connectivity leveraging the Azure CLI and PowerShell notebooks in Azure Data Studio. For the full Azure SQ...

Sourcing data from Azure SQL Database in Azure Machine Learning

In this tutorial, we will show how to source data from Azure SQL Database to use in a Machine Learning workflow.

What is Azure SQL? | Azure SQL for beginners (Ep. 3)

Azure SQL is composed of Azure SQL Database, Azure SQL Managed Instance, and SQL Server in Azure VM. Learn about the key differentiators between them. For th...