Click here to Skip to main content
16,017,376 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Everyone,

I just wanted to enquire from anyone who has experience with SQLite.

Is it possible to update a tables in an Oracle database with a data from a similar table in SQLite. The basic idea is to use SQLite as a backup for when the network goes down, and the dump missing data into Oracle database from SQLite database when the network is back up?

Thank you

Nicole.
Posted

1 solution

I think you could use Oracle Heterogeneous Services for this. Have a look at this[^]. Even though the example is for SQL Server, you could use ODBC connection to SQLite.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900