ABC Housing* being in the real estate industry provides a wide range of easy housing solutions. They mainly work towards achieving stability and development of the society. Their focus is on high quality, effective costs and providing the required services in coordination with the various categories of society, under distinguished leadership, creative talents and developed systems as well as using the best international practices.
Overview
ABC Housing* is running all their line of business web, application & databases server workloads under on-premises virtualized environment. Also, they are using Microsoft 365 for their email & Office apps. As part of their digital transformation & cloud adoption journey, ABC* engaged Infrassist Technologies Pvt Ltd. to provide professional services for modernizing their line of business application environment & in 1st phase all SQL database instances were migrated to SQL Managed Instances under Azure Cloud.
Technical Challenges
- On-Premises SQL Cluster instances were configured to use many of SQL Instance & Database level features. These aren’t supported by their respective cloud versions (Azure SQL Managed Instance)
- There were key blocker compatibility issues
- Also, there were couple of business applications where in requirement was to have an online migration (without any downtime – in real time)
Solution
All on-premises SQL Cluster Database instances were migrated to Azure SQL Managed Instances using Database Migration Service in flawless manner.
- To ensure maximum computability, a detailed discovery & assessment was performed for all on-premises SQL Server Instances using Database Migration Assistant tool.
- A pre-migration remediation was performed for all key incompatibilities and were rectified by means of a minor application-level code change request by working closely with the software development team.
- Design Azure Solution Architecture diagram illustrating new SQL Managed Instances, Virtual Networks, Subnets, Database Migration Service Components.
- Performed 1st Initial sync for all databases (application wise) & did thorough testing using Application UAT environment by changing database pointers to Azure Cloud.
- Scheduled & performed final migration of all databases (application wise) followed by delta synchronization.
- We managed to generate full database backup & periodic tail log backups before cutover to ensure minimum (almost zero down time), thus delivering seamless application browsing experience for business users.
Technologies Used
- Database Migration Assistant Tool
- Azure SQL Managed Instances
- Azure Database Migration Service
- Azure Virtual Network/Subnets, Backup & VPN Gateway Service
Accomplishment
Infrassist carried out a seamless migration of all SQL databases (leaving nothing on-premises) running under on-premises SQL cluster to Azure SQL Managed Instances (PaaS) under Azure Cloud.
