Customer Stories
OneAdvanced Makes Database Migrations to Azure SQL Faster and More Reliable
Xebia helped OneAdvanced migrate customer databases to Azure SQL using guided DevOps pipelines.

OneAdvanced, a UK-headquartered SaaS company with 2000+ employees worldwide, worked with Xebia to automate moving large SQL Server databases to Azure SQL Database. Xebia build an automated hybrid migration workflow on Azure, resulting in migration time cut from about 5 hours to 2, migrations that people without DevOps knowledge can run, and logs and diagnostic reports for every run.
At a Glance
Challenge
Large SQL 2000 and 2008 Server databases, one per OneAdvanced customer, needed a repeatable, auditable way to move to Azure SQL Database.
Solution
Xebia chained Azure SQL Managed Instance, SqlPackage and Azure SQL Database in 2 automated Azure DevOps pipelines.
Results
Migration time cut from about 5 hours to about 2, with every run logged for audit.
The Client
OneAdvanced is a UK-headquartered provider of sector-focused SaaS and business management software, serving customers worldwide. It employs approximately 2,100 to 2,200 people. OneAdvanced worked with Xebia to move its customer databases to Azure.
The Challenge: Required a repeatable, auditable way to move large databases to Azure SQL Database
OneAdvanced had to move large SQL Server databases to Azure SQL Database, Microsoft's fully managed database platform. Each OneAdvanced customer had its own database, so the process had to repeat customer after customer, leave an audit trail and run with as little manual work as possible.
No single Microsoft route fit. At these sizes, Azure Database Migration Service needed a very powerful integration runtime machine to reach target speed, and its classic version was being replaced by newer Microsoft tools. Exporting and importing .bacpac files took too long to run reliably on the largest databases.And OneAdvanced's own SQL Server .bak backups could not be imported into Azure SQL Database directly.
The Solution: Combining Azure services in two automated DevOps pipelines
Xebia tested each Microsoft migration route in practice against OneAdvanced's requirements and based its recommendation on the results. The chosen approach fits OneAdvanced's database sizes and the direction of the Azure platform.
A hybrid workflow
Each SQL Server backup is first restored into Azure SQL Managed Instance, which restores native backups quickly and works as a temporary staging area. SqlPackage then exports the database as a .bacpac file, which is imported into Azure SQL Database.
Two Azure DevOps pipelines
Xebia turned what started as a set of scripts into 2 pipelines. The first sets up secure, separate Azure Blob Storage for each OneAdvanced customer and issues time-limited upload access. The second restores, exports and imports the database in one run.
Security from the start
Azure Key Vault supplies passwords at runtime, and the pipelines sign in with a managed identity instead of stored credentials. Each OneAdvanced customer's data stays in isolated storage throughout the migration.
Sign-off and handover
Xebia delivered a checklist covering schema, data integrity, security, application behavior, performance and cutover, so the OneAdvanced team can sign off each migration with confidence. Xebia also handed over a run book, a step-by-step guide, technical documentation and an infrastructure and permissions overview.
Tech Stack:
- SQL Server
- Azure SQL Database
- Azure SQL Managed Instance
- SqlPackage
- Azure DevOps
- Azure Blob Storage
- Azure Key Vault
- Managed Identity
The Result: OneAdvanced now runs Azure migrations in about 2 hours
- Migration time cut from about 5 hours to about 2, measured against the earlier migration scripts.
- 2 Azure DevOps pipelines let people without DevOps knowledge run a migration by following a few steps.
- 6 areas covered by the sign-off checklist: schema, data integrity, security, application behavior, performance and cutover.
- Every run follows the same steps, with logs and diagnostic reports kept for audit.
Looking Ahead
OneAdvanced's own team can now run and maintain the migration process without relying on Xebia, moving its databases to Azure SQL Database customer by customer.
Contact









