On-premise Database to Azure Database using DMA (Data Migration Assistant)

Database Migration:

In this exercise, we are going to see how to migrate on-premise SQl DB to Azure SQL DB

Azure Migrate:

Create Azure Migrate project for Databases only.



Onprem DB:

Name of the on-premise DB is ‘OnpremDB’



‘MigratefromOnprem’ is the Azure SQL Database.



 

Install Data Migration Assistant on On-prem server which has full access to SQL DB server. DMA tool helps to conduct the assessment to check the dependency and compatibility. Once done we can run the migration.





Create a Project:



Check DB compatibility and Feature parity for an assessment



Add source DB for an assessment



Once assessment is done, upload the assessment to Azure Migrate Project  ‘Onprem2AzureSQL’





Assessment is now reflected in Azure Migrate project



 

Create Migration project in DMA:



Configure Source and Target SQL DB details



Select the target DB where the Source DB will migrate to



Select the Source Object to Migrate and generate SQL script



Script is ready and need to deploy Schema



 

Schema is deployed and it’s time to migrate



Select the Source DB name to migrate



Migration is successful.



Onprem DB’s table is now visible in Azure DB



 


Comments

Post a Comment

Popular posts from this blog

Why Azure Cloud

Image
Microsoft Azure    There are multiple cloud providers in the cloud market. However, only three cloud providers play a major role AWS, Azure, and Google Cloud. Each of them has its own advantages. In this article we are going to see what makes Azure to stand tall among all other cloud providers. Microsoft offers Azure as a cloud computing service. a collection of distinct cloud computing services, including remotely hosted and managed variations of proprietary Microsoft technology, are used to create, test, deploy, and manage cloud-based applications. ·           Offer almost 200+ Services. ·          It has 78 regions available in 140 countries which are huge compared to other cloud providers.   Microsoft Azure’s unique features and their benefits Infrastructure as a Service (IaaS) Microsoft Azure has spearheaded the development of IaaS, which allows businesses to manag...
Read more

Azure Active Directory Domain Services (AADDS)

Image
  Azure Active Directory Domain Services (AADDS)                                 AADDS is a service provided by Azure to maintain the legacy/on-prem applications on Azure cloud which can support only legacy/on-prem protocols like Kerberos, NTLM etc. This will work alongside Azure AD. Users part of Azure AD will be able to access the legacy servers using AADDS service. Users from On-premises will also be able to access the servers in Azure when you have done directory synchronization between On-prem and Azure AD using Azure AD Connect.                                 Azure AD DS provide one-way synchronization from Azure AD to the managed Domain. You can also control the syn...
Read more

Azure VPN Gateway

Image
  Azure VPN Gateway:             Azure VPN gateway is a service that uses a specific type of virtual network gateway to send encrypted traffic between an Azure virtual network and on-premises location over the public Internet. We can also use VPN gateway to send an encrypted traffic between Azure virtual network over MS network. When we create multiple connections, all VPN tunnels share the available bandwidth.             VPN gateway is composed of 2 or more Azure managed VMs deployed in a specific subnet called GatewaySubnet. The Gateway VMs contains routing table and run specific gateway services.             Gateway Type determines how the virtual network gateway will be used.             A virtual network can have 2 virtual network gateways. 1. ...
Read more