23 Million Records, Zero Errors - How a Leading Canadian Bank Moved Off DB2 with DQV
At a glance -
the essentials
One of the Top 5 Canadian Banks
- The bank's Retail Wealth Management Technology business wanted to migrate roughly 23 million records across 15 tables from its IBM DB2 database to a new MS SQL Server database on Azure cloud, supporting the Tax Estimator and Business Cash Flow Planning applications. Microsoft's own SQL Server Migration Assistant (SSMA) was evaluated first, but it required special privileges on the MS SQL server plus additional software installation, and it offered no way to compare source and target data once a migration ran. The bank needed both a reliable migration path and an independent way to confirm every record had moved across correctly.
- Use DQV product to run the migration across DIT, SIT, and PROD environments, then used DQV again post-migration to compare source and target - one tool for both steps, unlike SSMA
- Compare DB2 and SQL Server database structures directly to quickly flag any structural differences before data even moved
- Migrate all 15 tables and ~23 million records in 15 minutes, with no special server privileges or extra software installation
- Run a full, non-sampled 23-million-record comparison across all 15 tables in 10 minutes, confirming every record and every field matched
- Any differences at the field level, the team could pinpoint discrepancies immediately rather than combing through raw exports
- Data migrated from source to target with zero errors
- 100% of the 23 million records across all 15 tables confirmed fully matched - 0% mismatch
- Field-level difference highlighting let the team confirm migration accuracy within minutes, not hours or days
- Removed dependency on SSMA's privileged server access and extra software installation
- Combined migration and validation completed in 25 minutes end-to-end (15 min migrate + 10 min compare)
From a stalled DB2-to-SQL migration to a fully validated 23M-record cutover in 25 minutes.
Kumaran partnered with the Retail Wealth Management Technology team at one of the top 5 Canadian banks to migrate the Tax Estimator and Business Cash Flow Planning applications from IBM DB2 to MS SQL Server. After SSMA proved impractical - requiring elevated server privileges, extra software, and offering no data comparison - the team used DQV to run the migration itself and then validate it, moving and confirming roughly 23 million records across 15 tables with zero mismatches.
The Background
The bank's Tax Estimator and Business Cash Flow Planning applications ran on an ageing IBM DB2 database that needed to move to MS SQL Server. Microsoft's SQL Server Migration Assistant (SSMA) was the initial option, but it required special privileges on the SQL Server and additional software installation, and it had no built-in way to verify that migrated data actually matched the source. Without an independent comparison step, the team had no fast way to confirm a migration this size - 23 million records across 15 tables - had completed cleanly.
Want to know how we achieved these results?
Contact us today to learn more about our DQV-driven data migration approach and the success story behind this engagement with the Retail Wealth Management Technology team at one of the top 5 Canadian banks.
More proof
RECORDS COMPARED PER MINUTE, END TO END
1.9M
How We Automated ETL Regression Testing at Scale for an Enterprise Bank - 200M Records Validated in Under 2 Hours
The bank's Equity Markets & Prime Brokerage Technology business ran roughly 800 batches in production. Whenever batch logic changed, the team needed to regression-test every affected ETL job...
FASTER VALIDATION VS. MANUAL PROCESS
96%
96% Faster Data Reconciliation - Zero-Guesswork Validation for one of the Top 5 Canadian Bank's Global Derivatives Business
The bank's Global Derivatives/FICC business generated a massive volume of trade data every day from multiple source trading systems. Validating each record by hand made QA effort during SIT and UAT significantly high...