General Knowledge

Migration SQLite to and from Oracle

SQLite to Oracle

Data must typically be converted to text and then loaded using each database’s native loader utility. For example, use SQL*Loader to load the text files into an Oracle database. If you can make SQLite accessible via ODBC, you should also be able to use Oracle’s Heterogeneous Service to connect to it via a DB link.

An open-source library of Oracle-compatible SQLite functions has been written by students from the Kansas State University. Functions for other DBMS products have also been written.

The StepSqlite product from Metatranz LLC is a PL/SQL compiler for SQLite. It supports a subset of PL/SQL and can be used for code migration or parallel development between Oracle and SQLite.

About the author


Leave a Comment