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!
--
[email protected]
http://www.chicoree.fr
