SQLite和Oracle之间的数据传输 [英] Data transfer between SQLite and Oracle

问题描述

大家好，

我只是想向有SQLite经验的人打听.

是否可以使用SQLite中类似表中的数据更新Oracle数据库中的表.基本思想是使用SQLite作为网络故障时的备份，并在网络备份时将丢失的数据从SQLite数据库转储到Or​​acle数据库中?

谢谢

Nicole.

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.

推荐答案

我认为您可以为此使用Oracle异构服务.看看此 [

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.

这篇关于SQLite和Oracle之间的数据传输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！