Skip to content

Platform

AI database migration with rules and review

AI converts stored code, fixed rules handle tables, columns, types, keys and the data copy, and every AI conversion is checked before anything ships.

Example run · AI conversion / ERP-Oracle to ERP-PG
Package
FIN.PKG_GL_POSTING, 14 procedures, package state
Reviewed
AI draft, edited by Marcus Reed
Checked
Result columns match the source; test-called on the target
Compiled
PostgreSQL 16.4, before deploy

Scope

What does AI do and not do?

AI converts stored code and writes the plan summary, but it makes none of the final decisions.

  • Stored code

    AI converts procedures, functions, triggers and complex views.
  • Schema and data

    Tables, columns, types, keys and the data copy use fixed rules, not AI. They are predictable and repeatable.
  • What is deployed

    AI does not decide what is deployed. Compilation and review do.
  • Type mapping

    AI does not change type mapping decisions. A named approver does.
  • The verdict

    AI does not compute the validation verdict. Code does.
  • The record

    AI does not hide its work. Every AI draft and review is in the record.

Process

Where does AI sit in the process?

Every AI draft is checked, reviewed if needed and compiled before deploy.

  1. 1. AI converts stored code

    AI drafts procedures, functions, triggers and complex views. Schema and data use fixed rules, not AI.

    • Procedures
    • Functions
    • Triggers
    • Complex views
  2. 2. Every AI conversion is checked

    Its result columns must match the source, and it is test-called on the target.

    • Result columns match
    • Test-called on the target
  3. 3. People take what cannot be proven

    A named person accepts, edits or rewrites it. Each decision is recorded with their name.

    • Accept
    • Edit
    • Rewrite
  4. 4. The compiler has the last word

    Every converted object is compiled and checked on the target before deploy, on PostgreSQL inside a rolled-back transaction. Nothing AI-written is deployed silently.

    • 540 of 540 compiled

Example

How does AI handle an Oracle package?

AI drafted this package, a named engineer reviewed and edited it, and it compiled before deploy.

Oracle Database

FIN.PKG_GL_POSTING

Package, 14 procedures, package state

PostgreSQL 16.4

fin_pkg_gl_posting

Schema with functions and a session settings table

  • AI draft, edited by Marcus Reed
  • Compiled on PostgreSQL 16.4

Related

Questions

Frequently asked questions

Which AI model does Datalobe use?

Your organisation sets the AI model provider. Datalobe does not choose it for you.

How much code does AI convert?

AI converts stored code: procedures, functions, triggers and complex views. Tables, columns, types, keys and the data copy use fixed rules, not AI.

What stops a wrong AI conversion reaching production?

Each AI conversion's result columns must match the source, it is test-called on the target, and anything that cannot be proven goes to a named person. Code-object validation then compares results on both sides.

Demo

See AI conversion on your own code

Book a demo and bring the package you trust least.