db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Importing tables which have references to other tables
Date Mon, 18 Jun 2012 13:55:07 GMT
On 6/14/12 11:37 PM, 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
Hi Jan,

You might want to take a look at ForeignTableVTI, attached to 
https://issues.apache.org/jira/browse/DERBY-4962. Using that tool, you 
should be able to import directly from another database without having 
to indirect through a dump file.

Hope this helps,
-Rick
> ..........................
> 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:88nosaj@gmail.com]
> Sent: Friday, June 15, 2012 8:27 AM
> To: derby-user@db.apache.org
> 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!


Mime
View raw message