Blog

SQLShift Successfully Supported a Malaysian User's Migration from SQL Server to OceanBase
Mar 9, 2026
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 tran...
Read more
SQLShift Technical Practice: Making AI Truly Usable, Trustworthy, and Deployable in Database Migration
Dec 22, 2025
In database migration, AI is attracting high expectations. But one practical issue is becoming increasingly clear: if you rely only on a model, migration risk is not reduced and may even be ...
Read more
Practical Case Study: Migrating SQL Server Stored Procedures to OceanBase
Oct 22, 2025
As OceanBase adoption accelerates across key sectors such as finance, government systems, and large internet platforms, more SQL Server-based enterprises face the same challenge: How can SQL...
Read more
Practical Migration from Oracle to PostgreSQL 9.2
Jul 7, 2025
Table of Contents 1. Migration Background: Stored Procedure Compatibility Challenges 2. Automated Conversion in Practice: SQLShift Migration Capabilities 3. Conversion Result Validation 4. C...
Read more
System Function Migration
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. SQL Refactoring Plan for Target MySQL 3. Refactoring Summary 1. Key SQL Logic in Source Oracle Database CREATE OR REPLACE PROC...
Read more
Complex Numeric Type Conversion
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. SQL Refactoring Plan for Target MySQL 3. Refactoring Summary 1. Key SQL Logic in Source Oracle Database CREATE OR REPLACE PROC...
Read more
Hidden Symbol Differences Causing Stored Procedure Migration Pitfalls
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. Core Challenges in Migrating to OceanBase 3. SQL Refactoring Plan for the Target Database 4. Refactoring Summary 1. Key SQL Lo...
Read more
Dynamic SQL Variable Optimization and Complex Expression Decoupling
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. Core Challenges in Migrating to OceanBase 3. SQL Refactoring Plan for the Target Database 4. Refactoring Summary 1. Key SQL Lo...
Read more
Distributed System State Detection Logic Refactoring
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. Core Challenges in Migrating to OceanBase 3. SQL Refactoring Plan for the Target Database 4. Refactoring Summary 1. Key SQL Lo...
Read more
SYSDATE Compatibility Adaptation
Mar 26, 2025
Table of Contents 1. Key SQL Logic in Source Oracle Database 2. SQL Refactoring Plan for Target OceanBase 3. Refactoring Summary 1. Key SQL Logic in Source Oracle Database DELIMITER $$ ... S...
Read more