Vendor compatibility percentages describe their test environment. A SQL compatibility score should describe your workload.
For a database migration, use this reusable framework to evaluate compatibility with GBase Database.
5 Dimensions to Test
Core DML — 30%
Measure how many sampled statements run unchanged.
Procedural Code — 20%
Check procedures and functions that can be converted without manual rewrites.
Functions & Data Types — 15%
Verify built-in functions and data types against real application requirements.
Driver & Framework Support — 15%
Test whether applications connect without significant code changes.
Migration Toolchain — 20%
Evaluate schema conversion, data synchronization, compatibility scanning, and object comparison.
How to Use the Scorecard
- Extract the top 100 SQL statements by production frequency.
- Run the same workload against your target GBase Database environment.
- Record every failure and its root cause.
- Apply the predefined weights consistently.
- Use the results as evidence for migration planning.
The goal isn't to find the highest vendor-published percentage. It's to understand your actual SQL compatibility before committing to a migration.
One afternoon of production SQL sampling can reveal more than a dozen benchmark slides.
💬 Do you test real production SQL before choosing a database?
