AIA leading insurance provider in Indonesia migrated 65 SQL Server instances and 300+ databases, more than 10 TB of data, to Azure SQL Managed Instance with minimal downtime, supported by Geopits throughout the process.

Business Challenges

The client needs to modernize its database infrastructure while maintaining business continuity throughout the migration.

Complex interdependencies

Managing dependencies across 65 SQL Server instances required careful sequencing to avoid disruption.

Data integrity at scale

Maintaining accuracy and consistency across 300+ databases throughout the migration was critical.

Minimizing downtime

The business required continuous availability during cutover, leaving no room for extended outages.

Manual effort at scale

A large-scale environment of this size could not be migrated efficiently through manual processes alone.

Project Objectives

Geopits partnered with AIA, a leading insurance provider in Indonesia, to modernize its database infrastructure while ensuring business continuity across every instance.

Key Goals:

Migrate 65 instances and 300+ databases without disrupting operations
Preserve data integrity across complex interdependencies
Reduce manual effort through automation

Solution Provided by Geopits

Geopits executed a phased migration strategy using automated orchestration, dependency mapping, compatibility validation, and comprehensive pre- and post-migration testing. Migration health was tracked through continuous monitoring powered by GeoOps.

Phased migration strategy

Instances were grouped and sequenced in phases to control risk and preserve business continuity.

Automated orchestration

Automated tooling handled repeatable migration steps across all 300+ databases.

Dependency mapping and validation

Interdependencies were mapped, and compatibility validated before each phase moved forward.

Pre- and post-migration testing

Comprehensive testing before and after each cutover confirmed data integrity and performance.

Results & Business Impact

The migration reduced manual effort, accelerated timelines, and strengthened the client's operational resilience on Azure.

Capabilities

Before

After

Migration timeline

Slower, sequential execution

50% faster

Database coverage

65 instances, siloed environments

300+ databases migrated seamlessly

Business continuity

Risk of extended downtime

Minimal disruption during cutover

Scalability and DR

Limited on-premises capacity

Improved scalability, high availability, and disaster recovery readiness on Azure

Key outcomes

70% Reduction in Manual Migration Effort

Automated orchestration executed repeatable migration tasks across 300+ databases, reducing manual intervention by 70% compared to a fully manual migration process.

50% Faster Migration Timelines

Phased, dependency-aware migration sequencing enabled database instances to be migrated 50% faster than a traditional sequential approach while minimizing operational delays.

Improved Scalability & Disaster Recovery Readiness

Migration to Azure SQL Managed Instance enhanced scalability, high availability, and disaster recovery readiness, providing a more resilient and future-ready database environment.

Conclusion

Geopits partnered with AIA, a leading insurance provider, to migrate 65 SQL Server instances and 300+ databases to Azure SQL Managed Instance. Using an automated, phased migration approach, Geopits reduced manual effort, accelerated migration timelines, and ensured seamless business continuity with minimal disruption throughout the cutover.

Ready to Transform Your Data?

Geopits works alongside your team as a strategic partner, starting with stabilizing your current databases, then modernizing your data infrastructure, and ultimately helping you unlock the full potential of AI.

Book a Demo Learn More

170

Happy Clients so far

2100+

Databases Managed

142+

Successful Migrations

At Geopits, our mission is to empower businesses to achieve reliable, secure and high-performing database environments and to derive meaningful business insights.