Skip to content

v1.0.0 — Oracle/PostgreSQL → HeliosDB-Nano + stock PostgreSQL

Choose a tag to compare

View all tags
@danimoya danimoya released this 26 Jun 17:34
v1.0.0
c5bdb77

Any2HeliosDB v1.0.0 — first stable release

A modern, Python successor to Ora2Pg that migrates Oracle / MySQL / PostgreSQL / SQL Server → HeliosDB (Nano / Lite / Full) or stock PostgreSQL.

The v1.0.0 primary target — fully migrate Oracle → (PostgreSQL + HeliosDB-Nano) — is validated end-to-end: schema, data, sequences, views, PK/FK/CHECK constraints, and FK-indexes, including a million-row chunked/parallel load with crash-resume, and hardened through a three-round gpt-5.5 (xhigh) adversarial review (final verdict: safe to tag).

Highlights since 0.9.x

  • Oracle procedural & advanced objects surfaced (routines, triggers, materialized views, partitioned tables): counted in a2h assess, gap-reported, and written to a <schema>.review.sql companion for manual porting. (Auto-translation of PL/SQL → PL/pgSQL is the v2.0.0 roadmap — see docs/reference/oracle-object-support.md.)
  • Consistent read snapshot for chunked load + resume (AS OF SCN, captured once and reused across resume; graceful fallback with a warning if a table was just altered).
  • Oracle seq.NEXTVAL defaults → nextval('seq') (preserve-case aware) so sequence-default columns migrate with a working auto-increment.
  • PostgreSQL-source sequences migrate with correct resume points (validated Pagila → Nano: 15 tables / 49,636 rows, all validators green).
  • Robustness: safe identifier quoting, real-CHECK preservation (metadata-aware), collision-free TEST_DATA checksums, atomic native load_range, config-fingerprinted resume.

Install

pip install -U any2heliosdb

Apache-2.0. See CHANGELOG.md for the full list.

Assets 2
Loading