Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLite to Oracle

I have a SQLite database in one system, I need to extract the data stored in SQLite to Oracle database. How do I do this?

like image 679
DUrs Avatar asked Mar 04 '11 06:03

DUrs


People also ask

Is SQLite managed by Oracle?

While MySQL is managed by Oracle, SQLite's code is available for both personal and commercial use in the public domain.

Is Oracle and SQLite same?

The SQLite database does not provide the same SQL functionality as Oracle databases.


1 Answers

Oracle provides product called the Oracle Database Mobile Server (previously called Oracle Database Lite) which allows you to synchronize between a SQLite and an Oracle database. It provides scalable bi-directional sync, schema mapping, security, etc. The Mobile Server supports both synchronous and asynchronous data sync. If this is more than a one-time export and you need to keep your SQLite and Oracle Databases in sync, this is a great tool!

Disclaimer: I'm one of the Product Managers for Oracle Database Mobile Server, so I'm a bit biased. However, the Mobile Server really is a great tool to use for keeping your SQLite (or Berkeley DB) and Oracle Databases in sync.

like image 80
dsegleau Avatar answered Oct 06 '22 01:10

dsegleau