Hi im currently using some derby export methods to export table by table to a .del type of file. After which i will import the .del files using the import methods. You can take a look here:
http://db.apache.org/derby/docs/10.6/tools/ctoolsimport16245.html Bartosz, Jan (NSN - PL/Wroclaw) wrote: > > HI, > > I don't have answer to your question... however I'm just curious how > your export & import process looks like? - Export-> file and then from > file-> DB ? is there a way to export&import at same time from DB1->DB2 > let's say I want to make a copy from a subset of DB1 and copy it to DB2 > (without statement&ResultSet just by using some tools from DERBY). > Many Thanks for any help;)! > BR > Jan > > .......................... > Regards / Pozdrowienia > Jan Bartosz > MBB RP I&V Tools&Autom Pegasus Core PL > My contact info in Phonebook > Click to call me by using Softphone > > -----Original Message----- > From: ext jaz1988 [mailto:[email protected]] > Sent: Friday, June 15, 2012 8:27 AM > To: [email protected] > Subject: Importing tables which have references to other tables > > > Hi, > > I have a table, TABLE1 which has a column which is GENERATED BY DEFAULT > AS > IDENTITY. I managed to export this table and import into an existing DB > with > the same table. The import is able to adjust the IDENTITY column > accordingly > with regards to the existing data in the table. > > The problem is, I have another table, TABLE2 which has a foreign key > that > referenced to the IDENTITY column in TABLE1. When the IDENTITY column in > TABLE1 is adjusted after import, the import of TABLE2 will fail since > the > References is messed up already. Am I doing it right or is there other > ways > to do import and exports of Tables with references. > > Thank you! > -- > View this message in context: > http://old.nabble.com/Importing-tables-which-have-references-to-other-ta > bles-tp34016274p34016274.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > > > -- View this message in context: http://old.nabble.com/Importing-tables-which-have-references-to-other-tables-tp34016274p34016712.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
