Table of Contents

• 1. Project Background
• 2. Core Pain Points
• 3. Solution Profile
• 4. Business Value
• 5. Closing Remarks

1. Project Background

As overseas gaming business grew rapidly, both transaction volume and data scale kept increasing. The customer’s original SQL Server architecture in Malaysia gradually ran into multiple bottlenecks:

• Heavy pressure from high-concurrency writes: lock contention and log pressure became obvious during peak traffic, and throughput failed to scale linearly with business growth.
• High latency in real-time queries: frequent cross-month transaction queries reached latency peaks of nearly 2 seconds, impacting risk control and operational analytics.
• Uncontrolled index and storage costs: only 3 GB of business data corresponded to 12 GB of indexes, extending maintenance windows and raising operational risk.

To improve elasticity and scalability, the customer selected OceanBase distributed database as its next-generation data platform.

During migration, one key challenge became clear:
How can business-critical logic encapsulated in stored procedures be migrated safely, quickly, and cost-effectively?

2. Core Pain Points

The real hard part of database migration: stored procedures

Across the customer’s three core business databases, more than 90 stored procedures supported the full transaction chain. The average procedure exceeded 1,000 lines and contained multi-level nested logic and complex business rules, covering 10+ key modules such as game top-up, reporting, and logging. These procedures mainly handled:

• Complex cross-table calculations
• Encapsulation of business rules
• Batch processing and transaction control

At the same time, the code heavily relied on T-SQL-specific syntax, system functions, and custom control flow, which further increased migration difficulty.

If traditional manual migration is used

• Rewriting line by line creates a massive workload
• High semantic interpretation cost and difficult-to-control go-live risk
• Timelines measured in months
• Long-term occupation of DBA and R&D resources

3. Solution Profile

SQLShift in action: true automation for non-table object migration

To solve this bottleneck, the project adopted SQLShift, a multi-database non-table object migration platform focused on the most complex part: stored procedures. Using an LLM plus a rule engine, SQLShift performs intelligent conversion at both syntax and semantic levels. In this project, it delivered:

• Fully automatic conversion from SQL Server stored procedures to OceanBase (MySQL mode)
• Coverage of complex logic including control flow, cursors, variables, and exception handling
• Deep adaptation and fixes for OceanBase execution characteristics
• Consistent business logic with much lower regression-testing cost

Project outcome: one-pass successful migration of core stored procedures

Final results were clear:

• All core stored procedures across three business databases were migrated successfully.
• Converted procedures ran stably on OceanBase directly.
• The migration cycle was shortened from weeks of manual rewriting to rapid batch conversion.
• DBA and R&D teams focused only on validation and optimization instead of rewriting from scratch.

4. Business Value

Why do enterprises choose SQLShift for migration?
SQLShift is not a simple syntax replacement tool. It is an enterprise-grade automation platform for non-table object migration:

• Supports major databases including Oracle, SQL Server, PostgreSQL, GaussDB, and OceanBase
• Focuses on high-complexity objects such as stored procedures, functions, and triggers
• Deeply adapts to local innovation and domestic database replacement scenarios
• Converts risky manual migration into a measurable, scalable, and repeatable standard process

5. Closing Remarks

In database migration, the challenge is never only “tables.” Non-table objects such as stored procedures, functions, and triggers are the true deciding factors for success and schedule.
From SQL Server to OceanBase, and from legacy architectures to distributed upgrades, SQLShift is becoming a reliable accelerator for enterprise database migration.
SQLShift makes complex migration more controllable, more efficient, and more scalable.