db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Leroux <sylv...@chicoree.fr>
Subject Using IJ to copy data from one DB to an other one
Date Mon, 15 Feb 2010 18:44:13 GMT
Hi,

Is it currently possible to use IJ to copy data from one DB to an other one? I 
mean, without writing any line of Java...

By looking at the code, it seems that prepared statements and cursors are tight 
to one specific DB connection. Thus preventing something like:

CONNECT 'jdbc:derby:src_db'
PREPARE SRC AS 'SELECT x FROM SOURCE_TABLE';

CONNECT 'jdbc:derby:dest_db'
PREPARE COPY AS 'INSERT INTO DEST_TABLE VALUES(?)';
EXECUTE COPY USING SRC;


Thanks,
Sylvain

PS/If such a feature is not available, I'll be glad to work on it!


-- 
sylvain@chicoree.fr
http://www.chicoree.fr



Mime
View raw message