Making copies of Oracle database tables in a SQLite database

Question

I have 2 databases, Oracle and SQlite. And I want to create exact copies of some Oracle tables in SQLite in one of my applications. Most of these tables contain more than 10,000 rows, so copying each table through each row programmatically is inefficient. Also, the structure of the table may change in the future, so I want to achieve this using a common method without hard coding SQL statements. Is there any way to do this?

ps - This application is developed using the Qt platform. All queries and databases are represented by QtSql module objects.

Answer 1

It is not possible to help with the Qt map, but for large amounts of data it is usually better to use bulk copy operations.

Exporting data from Oracle http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/impexp.htm#BCEGAFAB

Import data into SQLite http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles

Ihth

Answer 2

What you probably really want to use is the Oracle Database Mobile Server , which can automatically synchronize SQLite and the Oracle database.

A recent version of Oracle Database Mobile Server (formally called Oracle Database Lite Mobile Server) supports synchronization between an Oracle database and a client-based SQLite or Berkeley DB database. It supports synchronous and asynchronous data exchange, and also provides secure communication between the client and server. You can configure Mobile Server to synchronize based on several parameters without having to change the application that accesses the database.

You can also find a great discussion forum.