Microsoft gold partner in india - ifi tech

Migrating data from On-Premises MySQL to Azure database for MySQL using DMS

Author- Kriti Bhardwaj(Data Engineer) In this documentation you will learn how to migrate On-premises MySQL to Azure database for MySQL using DMS. Here I have taken demo sample database to migrate with minimal downtime. Pre-requisites: Create Azure database for MySQL. Create a virtual machine. Create DMS. Install MySQL workbench. Both Azure database for MySQL and…

SQL Database Migration to Azure Using Data Migration Assistant (DMA) - ifi tech

SQL Database Migration to Azure Using Data Migration Assistant (DMA)

Data Migration Assistant The Data Migration Assistant is migration tool developed by Microsoft. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL database. DMA recommends performance and reliability improvements for your target…

Bicep: Modern language for ARM Template?

Infrastructure as a Code Infrastructure as code is the process of automating your infrastructure (networks, virtual machines, load balancers, and connection topology) provisioning. It uses a descriptive coding language and versioning system that is like what is used for source code. Idempotence is a principle of Infrastructure as Code. Azure provides native support for IaC via the Azure…

microsoft cloud solution provider in hyderabad - ifi tech

SSO Configuration using SAML v2.0 and Azure Active Directory for Custom web application

Author: Ajinkya Bhabal, Cloud Engineer. Introduction What is SAML v2.0? It is an open standard for exchanging authentication and authorization data between an identity provider and a service provider. The best use cases will be building Single Sign-on for applications. Here we will deploy our web application in Azure virtual machine and Azure Active Directory…

Microsoft gold partner in india - ifi tech

Database migration from Managed Instance to SQL Server with transactional replication

Author- Ashfaq Pathan (Associate Data Engineer) Transactional Replication Setup We will set up a transactional replication for migrating the database from Managed Instance to SQL Server 2017 hosted on Azure SQL-VM. Managed Instance will be both Publisher and Distributor. SQL Server will be Subscriber. Prerequisites: 1. Azure Subscription. 2. Storage account with one file-share in it…