Hi,

what would be the best way to copy a set of tables (structure and data) from
one database to another? The tables have foreign keys between each other but
not to tables out of the set. One of the tables contains a blob column. The
tables may or may not exists in the target database. If the tables exists
they have to be deleted because the table structure may have changed since
last transfer. Optional but not necessary it would be fine to have this
process in a batch for further use.

TIA

Chris Werner
f+s software gmbh

I would start with `dbunload -t <table_list> ` myself.

Modifying the reload.sql to check for the tables' existences
may will be required.

PowerDesigner may be a much cleaner way of going though.

"Chris Werner" <cwAT{PleaseNoSpam}f-s.de> wrote