Data Migration: Oracle → SQLite (Mixed Data Types)

Migrated two related Oracle tables (DEPARTMENTS, EMPLOYEES: text, numeric, decimal, date and BLOB columns, 50,000 rows with real images, ~136MB) to SQLite using three compared approaches: a full DBeaver transfer into a hand-built schema with PK/FK constraints, a JOIN export into an auto-created table, and a JOIN export via CSV staging. I solved Autonomous Database mTLS connectivity by configuring the wallet keystore and truststore. Post-migration validation caught DATE values silently converted to Unix timestamps, which I fixed with SQLite date().