Tag
#migration
33 entries across blog, tutorials, videos, podcasts, and code.
- Blog
Reading a Codebase Like a Migration Engineer: Inside Swordfish's Code Explorer
You wouldn't renovate a house you've never walked through. So why migrate a codebase you've never mapped?
- Tutorial
Migrating the Code, Not Just the Schema: One App, End-to-End
The capstone: take one sample app through the full funnel — assess, review findings, edit a recommendation, hand a scoped prompt to your copilot, diff the .new files, test.
- Blog
Security for a Tool That Reads Your Entire Codebase
A migration tool needs to read all of your proprietary source. That should make you suspicious — and it should shape how the tool is built.
- Blog
Engineering War Story: The Day We Found Our Rescan Could Eat Your Findings
A confession about a bug in our own tool, and the two database quirks that made fixing it harder than it looked.
- Blog
Why "Lift and Shift" Is a Lie for Heterogeneous Migrations
The phrase was invented for moving the same database to new hardware. Using it for Oracle-to-Postgres is how budgets die.
- Blog
Drowning in 20,000 Findings: Designing for Signal, Not Noise
A wall of 20,000 red rows isn't an assessment. It's a really thorough way to make a developer close the tab.
- Blog
Finding the SQL Nobody Knows They Have
You grepped for `SELECT` and found 200 queries. There are 1,400. This post is about the other 1,200.
- Blog
Assess, Don't Automate: The Migration ROI Most Tools Get Wrong
"90% automated" is a great pitch and a terrible plan, and the gap between them is where your migration actually lives.
- Blog
Right-Sized AI: Why You Don't Need GPT-5 to Migrate a Stored Procedure
The reflex to reach for the biggest model is expensive, often unnecessary, and sometimes flatly disqualifying.
- Blog
We Don't Apply Changes For You — On Purpose
Every other tool is racing toward "full autonomy." We built the brakes in, and I'd make the same call again.
- Blog
The Schema Is the Easy Part: A Field Guide to Behavioral Traps
A catalog of the migrations that pass every test, ship clean, and quietly corrupt your data three weeks later.
- Tutorial
Sybase → PostgreSQL: A Worked Example
A worked Sybase to PostgreSQL example: the shared T-SQL heritage with SQL Server, its own quirks, and where name-level introspection and dump-parsing take over.
- Blog
Why We Run Multiple LLMs (and Make Them Argue)
One model gives you one confident answer. The problem is "confident" and "correct" aren't the same word.
- Tutorial
DB2 → PostgreSQL: A Worked Example
A worked DB2 to PostgreSQL example: FETCH FIRST n ROWS ONLY, SYSIBM.SYSDUMMY1, VALUES quirks, identity columns, and SQL/PL to PL/pgSQL patterns.
- Tutorial
Moving and assessing Oracle application code to Postgres using Swordfish
Drive the Swordfish web UI through a full Oracle to Postgres assessment of the HR demo: read the grade, find the critical PL/SQL findings, turn 336 findings into a plan.
- Tutorial
Moving and assessing MySQL application code to Postgres using Swordfish
Drive the Swordfish terminal UI through a full MySQL → Postgres assessment of a real PHP app — find the embedded SQL, read what breaks, export the plan.
- Blog
Heuristics + AI: Why Deterministic Rules Come First
The cheapest, most accurate part of Swordfish doesn't use AI at all. That's not an accident.
- Tutorial
SQL Server → PostgreSQL: A Worked Example
A worked SQL Server to PostgreSQL example: TOP, IDENTITY, GETDATE/ISNULL/LEN, bracket identifiers, MERGE, and READ UNCOMMITTED habits.
- Blog
The Stuff That Isn't in the Code: Inferred Knowledge and Why Migrations Lose It
Your application knows things it never wrote down. The migration is where it forgets.
- Tutorial
MySQL → PostgreSQL: A Worked Example
A worked MySQL to PostgreSQL example: AUTO_INCREMENT, backtick identifiers, ENUM, ON DUPLICATE KEY, GROUP BY ordering, and the dump-to-PG rewrite path.
- Blog
A Tour of the Swordfish Sample Apps (and What Breaks in Each)
The hardest part of evaluating a database migration tool is finding something honest to point it at.
- Blog
Swordfish: A Harness for Your Copilot, Not Migration-in-a-Box
We're not trying to replace your LLM. We're trying to make it stop guessing.
- Tutorial
Oracle → PostgreSQL: A Worked Example
A worked Oracle to PostgreSQL example: the constructs Swordfish flags most (CONNECT BY, ROWNUM, NVL, packages), the recommended PG/EPAS change, and the human-review step.
- Code
mega-app — Oracle multi-language order management
A Java · Go · Python · PHP multi-language order management on Oracle, built to break the way real migrations do. A Swordfish Sample App for testing the Oracle→PostgreSQL assessment.
- Blog
Why Database Migrations Are a Developer Problem
The schema is the easy part. The code is where migrations go to die.
- Code
ecommerce-php — MySQL e-commerce storefront
A PHP 8 e-commerce storefront on MySQL, built to break the way real migrations do. A Swordfish Sample App for testing the MySQL→PostgreSQL assessment.
- Code
api-node — MySQL mobile & social REST API
A Node.js · Express mobile & social REST API on MySQL, built to break the way real migrations do. A Swordfish Sample App for testing the MySQL→PostgreSQL assessment.
- Code
hr-dotnet — SQL Server HR & payroll
A C# · .NET 8 HR & payroll on SQL Server, built to break the way real migrations do. A Swordfish Sample App for testing the SQL Server→PostgreSQL assessment.
- Code
etl-python — SQL Server data-warehouse ETL
A Python · pyodbc data-warehouse ETL on SQL Server, built to break the way real migrations do. A Swordfish Sample App for testing the SQL Server→PostgreSQL assessment.
- Code
claims-java — IBM DB2 insurance claims
A Java · JDBC insurance claims on IBM DB2, built to break the way real migrations do. A Swordfish Sample App for testing the IBM DB2→PostgreSQL assessment.
- Code
actuarial-python — IBM DB2 actuarial analytics
A Python · ibm_db actuarial analytics on IBM DB2, built to break the way real migrations do. A Swordfish Sample App for testing the IBM DB2→PostgreSQL assessment.
- Code
trading-java — Sybase ASE trading & settlement
A Java · JDBC trading & settlement on Sybase ASE, built to break the way real migrations do. A Swordfish Sample App for testing the Sybase ASE→PostgreSQL assessment.
- Code
risk-python — Sybase ASE risk reporting
A Python risk reporting on Sybase ASE, built to break the way real migrations do. A Swordfish Sample App for testing the Sybase ASE→PostgreSQL assessment.
