Well, what I do is keep an empty structure of the database (+ tables), copy everything to a temp directory, and issue APPEND FROM for each table. Additional considerations: 1) in the case of RI, the parent table has to be copied before the child tables. Otherwise (if the third RI column is "R") you get "trigger failed". 2) to speed things up, I do a detailed comparison of table structures. If the structures are identical, the table is copied with the COPY command.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
