Project Information
Country
United State
Industry
Organization Size
Solution Area
Products & Services
• Azure DMS
• Azure Managed Instance
• Azure SQL Database
• Azure Virtual Machine
About Company
Company provides a secure enterprise-grade assessment platform and professional services to leading organizations around the world. Its full-service online assessment tool and professional services help customers to improve their performance and meet their compliance requirements. They enable organizations to unlock their potential by delivering assessments which are valid, reliable, fair and defensible.
Project Summary
Client had multiple datacentres in USA and Europe with massive number of databases that they wanted to bring to Azure over the Azure Elastic Pool to save cost. They wanted an efficient way of migrating these databases to Azure with a few clicks and minimal amount of downtime. We were able to migrate 1000+ databases to Azure in a fully automated solution. This project had the highest amount of visibility within the Microsoft product team and resources were committed to ensure project is a big success.
Challenge
Due to clients large no. of databases residing in 2 different regions (USA and Europe) ranging close to 500-600 databases in each region, a manual approach to migration would have been a recipe for disaster. It was important to have an automated solution with various number of PowerShell scripts utilising multiple Azure services. This solution should be able to create databases, migrate schemas to destination databases and then perform actual migration for 100s databases at a time.
Solution
We assigned a team of certified Azure experts who did a deep analysis in 14 days to understand the environment and requirements, finally choosing Azure DMS for the job. Azure DMS offline and online service made it possible to migrate on-premise data to Azure Managed Instance and Azure SQL Database. Our team built a PowerShell script which works in 5 simple steps for offline and online migration. This involved creating databases as an exact number which are there at source (considering 1 on-premise datacenter), schema deployment to destination, setting up migration and building the DMS activities to migrate 10 databases in each activity.
We considered pros & cons of Azure DMS and worked closely with Microsoft product team in Seattle to come up with the plan to migrate all the databases within a short downtime-period requested by the client for minimal business impact. The meticulous planning, POC and testing by our engineers over a period of 2 months led to a successful migration.
During this process our team also helped the Microsoft Product Team with close feedback and even reported bugs that helped improve the Azure DMS service.
Connect with IFI Tech
Related Projects
Indian Red Cross Society upgrades operations from Navision to Microsoft Dynamics 365 Business Central
Project Information Country India Industry Nonprofit Organization Size 1,200+ Branches Nationwide1.5 Lakh Members1000+ Volunteers29 State Branch750+ District Branch Solution Area ERP & HRMS Products &
Shri Laxmi Group migrates SAP HANA workloads to Azure, reducing infrastructure costs and improving performance reliability
Project Information Country India Industry Manufacturing Organization Size 51–200 Employees Solution Area SAP HANA on Azure and Linux Migration Products & Services • Microsoft Azure•
NPB Consultant centralizes security monitoring using Microsoft Sentinel on Azure
Project Information Country India Industry Healthcare Organization Size 500+ Employees Solution Area Data Products & Services • Microsoft Sentinel• Azure Monitor Agent About Company NPB
Insights
The 8 Benefits of Working with an Azure Expert Managed Services Provider
Launching virtual machines and moving workloads to the cloud is only one part of working with Azure. The real challenge starts after that. Managing cloud
Unlock Your Azure Cloud Potential with the Right Azure Managed Services Partner
As businesses continue to digitize their operations, the demand for reliable and scalable computing environments has increased. Teams are expected to deliver faster, maintain performance,
IFI Techsolutions Earns Microsoft Advanced Specialization: Migrate Enterprise Applications to Azure
IFI Techsolutions is proud to announce that we have earned the Microsoft Advanced Specialization: Migrate Enterprise Applications to Azure. This recognition reflects our ability to