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.

‌

Regions:

Capabilities:

Industries:

Partners:

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

Let’s discuss how we can support your journey.

‌
‌
‌
‌
‌
‌
‌
‌
‌