Simon Hax wrote:
> for clearification:
>
> the roots of the question:
> business needs; our client has a big Oracle infrastructure.
> Now they want, in relation to their infrastructure a litte App based on
> SQlite.
>
> as I mentioned earlier:
> to copy data from an Oracle DB to another Oracle DB
e defineable by ATTACH (IP-Adress:Port,
OracleSID, UserId, Password)
that would be heaven on earth.
-Ursprüngliche Nachricht-
Von: Gary_Gabriel
Gesendet: 05.06.2010 16:02:14
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Oracle connection
Hi Pavel,
> Note: SQ
Hi Pavel,
> Note: SQLite *API*, nobody says about databases. These words from
> press-release basically say that now Berkeley DB "back end" has
> SQLite's "front end", i.e. you can work with BDB database through the
> same set of functions as with SQLite database. But you cannot mix them
> with ea
> Oracle has advertised on this
> list that Berkeley Db attaches to backend SQLite databases. Based on the
> Oracle concepts summarily presented; use Berkeley Db to connect Oracle
> to SQLite to achieve your targets if you cannot Attach.
Whoa!!! Please don't misguide poor Simon and read Oracle's
p
Simon Hax wrote:
> I don't know what JET is.
> I testet ADO. That works.
> But it'is slow and you have to write some (to much) code.
>
> Much more better would be a solution like a direct LINK (like an Oracle
> Database Link).
>
> as shown in my first email:
>
> insert into sqlitetable_columA sele
http://tinyurl.com/29sk9pr
On Thu, Jun 3, 2010 at 12:09 PM, Simon Hax wrote:
> I don't know what JET is.
> I testet ADO. That works.
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I don't know what JET is.
I testet ADO. That works.
But it'is slow and you have to write some (to much) code.
Much more better would be a solution like a direct LINK (like an Oracle
Database Link).
as shown in my first email:
insert into sqlitetable_columA select ColX from ta...@oracledb
If yo
On 3 Jun 2010, at 4:25pm, Simon Hax wrote:
> Is something possible like
>
> insert into sqlite_table.ColumnA select x from ta...@oracledb
>
> ?
> (Without copying into local memory (firstly do a select from Oracle )
> and then insert into a Sqlite database (via e.g. ADO ). )
>
> S.
Which set o
MSFT JET supports heterogeneous data sources. Assuming you have a JET MDB
with a data-connection to Oracle and another data-connection to SQLite, and
have attached the relevant tables from each, you could move data from one
back-end data source to the other. This approach brings the data from the
On 3 Jun 2010, at 4:25pm, Simon Hax wrote:
> Is something possible like
>
> insert into sqlite_table.ColumnA select x from ta...@oracledb
>
> ?
> (Without copying into local memory (firstly do a select from Oracle )
> and then insert into a Sqlite database (via e.g. ADO ). )
Which set of func
Is something possible like
insert into sqlite_table.ColumnA select x from ta...@oracledb
?
(Without copying into local memory (firstly do a select from Oracle )
and then insert into a Sqlite database (via e.g. ADO ). )
S.
___
GRATIS für al
11 matches
Mail list logo