SQL Tran is live.
We ran a live, end to end demo: a real Oracle database translated to PostgreSQL, the target database created, and thousands of tests generated and run, all in seconds. If you missed it, the full recording is on our YouTube channel and the link is at the bottom of this post.
Here is what SQL Tran does, what it took to build, and why we think the industry standard for automated SQL translation needs to change.
The problem with Oracle to PostgreSQL migration
Industry standard for automated SQL translation success is 50 to 70 percent, whatever vendors say.
The remaining 30 to 50 percent is dropped on a senior engineer who now has to read through translated code looking for the parts the tool got wrong.
That is not translation. That is shifting the work.
There is a second problem nobody likes to talk about. On a serious codebase, say half a million lines of database code, the legacy tools need a day or two just to run the assessment, then more time for the translation, before anyone has even started thinking about testing. Slow iteration means weak verification, and weak verification means surprises in production.
What SQL Tran does
SQL Tran is a high speed, fully automated SQL code translator with a built in static analysis engine and automated test generation.
In the launch demo, we translated an anonymized customer schema of 85,000 lines of Oracle code, with roughly 2,000 objects including 1,200 tables, 96 procedures, and 500 triggers, to nearly 100 percent in seconds. Then we did it again with a 500,000 line database. Same result, same speed.
On our largest tested codebase, SQL Tran translates 2.7 million lines of Oracle code to PostgreSQL in about 20 seconds. It typically lands at 95 to 99 percent translation accuracy on real codebases, and it is up to 1,000 times faster than competing products.
Currently supported translations: Oracle to PostgreSQL, SQL Server to Microsoft Fabric Warehouse, and Synapse Analytics to Fabric Warehouse.
It includes the parts most database migration tools leave to you:
- Full semantic analysis with data lineage and impact analysis, so you know what every identifier refers to and what depends on it
- Automatic creation of the live target PostgreSQL database, straight from your Oracle schema dump
- Business logic correctness testing that compares source and target behavior
- Synthetic test data generation that conforms to your schema, respecting data types, check constraints, uniqueness, and foreign keys
- Hundreds of built in emulations for cases where naive syntax translation would change behavior
What we showed in the live demo
A few things from the launch that are worth calling out, because they are what set SQL Tran apart from a syntax converter.
Idiomatic, lock free PostgreSQL. We work hard to generate clean, idiomatic PostgreSQL and to avoid external extensions wherever possible. Roughly 99 percent of the time we translate everything out of the box, so your result runs on open source PostgreSQL. No lock in to EDB, no lock in to a specific cloud provider's extensions. That matters because the whole point of leaving Oracle is to stop being locked in.
Hard things, handled. Oracle packages do not exist in PostgreSQL, so we emulate them. CONNECT BY, LISTAGG, complex aggregations, recursive logic, nested procedures: all emulated faithfully. In the demo we navigated the data lineage of a single table and saw every object that reads from it and every object that writes to it, without needing a live database to figure it out.
From script to tested database in seconds. We started from nothing but an Oracle schema dump, created a live PostgreSQL database, generated synthetic data conforming to the schema, then generated and ran roughly 1,700 tests across tables, views, functions, procedures, and packages. The result: 99.9 percent of the code behaved identically in source Oracle and target PostgreSQL. That is the number that should matter to anyone scoping a migration.
How it works
Short version: we did not build a syntax substitution tool. We built a full SQL compiler.
SQL Tran parses your codebase into a complete semantic model. Every identifier is bound to its definition. Every reference is tracked. As far as we know, we are the only vendor doing full static analysis across an entire database. We know what your code means before we translate it, and we translate to preserve meaning, not surface syntax. Static analysis also catches broken references in your existing code, so SQL Tran finds bugs you have been carrying for years.
This is also why we are fast. Recent parser benchmarks:
- Simple SELECT (300 characters, two table join): 6.6μs
- Medium SELECT (1kB, four tables, aggregates, complex WHERE, GROUP BY, ORDER BY): 20.3μs
- Complex SELECT (10kB, 8 CTEs including recursive, aggregates, JSON, window functions): 157.2μs
Pretty sure we have the fastest SQL parser in the world right now. And the fastest SQL static analysis.
Speed matters because when iteration speed is thousands of times faster than industry standard, you get to set verification standards nobody else can match. That is how we typically manage 95 to 99 percent success on real projects instead of 50 to 70.
Testing: the part most tools skip
Translation that you cannot verify is just a guess. SQL Tran tests by comparing real behavior between source and target.
Tables are tested by confirming source and target hold exactly the same data. Views are tested by running them and comparing results. Functions are tested by calling them with sampled parameters. Procedures are tested for side effects: we know from static analysis which tables a procedure touches, so after running it in both databases we compare those tables, then roll back. Triggers are accounted for by leaving them active and confirming the end state matches.
And you do not write these tests by hand. SQL Tran generates them, up to 20 per object, in seconds. In the demo we generated around 1,700 tests almost instantly.
SQL Tran and Omni Loader: code and data
SQL Tran handles your database code. Its companion, Omni Loader, handles your data, moving millions of records per second, hundreds of terabytes if needed, with on demand comparison, sync, and change data capture for continuous transaction streaming between Oracle and PostgreSQL.
Together they are a full Oracle to PostgreSQL migration solution that gets you to a near zero downtime cutover.
On the non believers
One of our business partners is a consultant who delivers end to end migration services powered by our software.
Two of his customers recently told him he had been tricked. Because "software can't do that."
I get the disbelief. The industry has been quoting long migration projects for a long time.
This is going to be an uphill battle. We will just have to prove them wrong. The live demo was the first step, and the recording is there for anyone who wants to check the claims for themselves.
How to get started with SQL Tran
You can try SQL Tran for free right now. Upload your Oracle schema (we read the schema only, never your data) and get an instant assessment report listing every potential issue and how much translates automatically. The assessment is produced by running the real translation and then surfacing the findings, not by guessing.
Pricing is based on the semantic complexity of your database, measured in nodes. For the largest and most complex projects, our consulting arm can run the whole migration for you, and we have delivery partners worldwide.
What is next
More platforms. More dialects. We have two more announcements coming in June alone.
Our database security solution, Safe Boundary, is also coming soon. Same parsing engine, same speed, a different problem. More on that when it ships.
Watch the full launch demo on demand
The complete June 4 launch, including the live translation of an 85,000 line and a 500,000 line Oracle database, the data lineage walkthrough, and the automated test generation, is available on demand.
Bring us your hardest SQL
Not a demo schema. Your real code. We will run it through SQL Tran and show you what the translated output looks like, what the tests look like, and what your timeline could be.
By the time you would typically get the initial assessment from a traditional vendor, you will be done with the whole project.
Let us prove it.
Get in touch about SQL Tran
Start free at spectralcore.com/sqltran
Email us at sales@spectralcore.com
Frequently asked questions
How accurate is automated Oracle to PostgreSQL translation with SQL Tran?
SQL Tran typically achieves 95 to 99 percent translation accuracy on real Oracle to PostgreSQL projects. By comparison, the industry standard for top-of-the-line automated translation tools is 50 to 70 percent. SQL Tran reaches higher accuracy because it performs full static analysis across your entire database, building a complete semantic model that understands what your code means rather than just substituting syntax. In our launch demo, 99.9 percent of a real codebase behaved identically in source Oracle and target PostgreSQL after translation and testing.
How long does an Oracle to PostgreSQL migration take with SQL Tran?
Code translation takes seconds, not months. SQL Tran translates 2.7 million lines of Oracle code to PostgreSQL in about 20 seconds, and it ran live translations of 85,000 and 500,000 line databases in seconds each during its launch. The full migration timeline depends on your testing and review needs, but the work that traditionally consumes most of a 12 to 18 month project, manual code rewriting, assessment, and test creation, is reduced to a fast, repeatable, automated step.
Does SQL Tran lock me into a specific PostgreSQL distribution?
No. SQL Tran generates clean, idiomatic PostgreSQL that runs on open source PostgreSQL, with no lock in to EDB, AWS, or any specific cloud provider's extensions. Roughly 99 percent of the time it translates everything out of the box without relying on external extensions. This is by design, because the purpose of leaving Oracle is to escape vendor lock in, not trade it for a new one.
Is there a free version of SQL Tran?
Yes. You can try SQL Tran for free by uploading your Oracle schema and receiving an instant assessment report that shows exactly how much of your database translates automatically and flags every potential issue. SQL Tran reads only your schema, never your data. The assessment is generated by running the real translation and surfacing the findings, so it reflects actual results rather than an estimate. Paid plans start at $4,000 per month, priced by database complexity.
What is SQL Tran?
SQL Tran is a high speed, fully automated SQL code translator built by Spectral Core for database migrations. It converts an entire database codebase, including tables, views, procedures, functions, triggers, and packages, from one platform to another. It currently supports Oracle to PostgreSQL, SQL Server to Microsoft Fabric Warehouse, and Synapse Analytics to Fabric Warehouse. SQL Tran includes a built in static analysis engine, automatic target database creation, and automated test generation to verify that business logic is preserved.
How does SQL Tran handle data migration, not just code?
SQL Tran translates database code, while its companion product Omni Loader migrates the data. Omni Loader moves millions of records per second, handles hundreds of terabytes, and supports change data capture for continuous transaction streaming between Oracle and PostgreSQL. Used together, they provide a complete Oracle to PostgreSQL migration solution, from code translation and target schema creation through data movement and testing, enabling a near zero downtime cutover.
About SQL Tran:
SQL Tran parses every dependency, translates with full semantic awareness, and generates the tests that prove behavior. Hundreds of thousands of lines per second. Deterministic. AI-free. Get in touch.
