>Hello all...
>What would be the best way to use tables from a database into a new database?
>Im trying to improve an old application using the data already stored in it, but when I try to copy the old tables, even if I change their names, I get the message "Table could not be copied because it belongs to database suchandsuch"... (or something similar.)
>
>Thanks in advance
For updating the structure, I first make all structural changes in an empty database. That is, the "empty" database has all tables, indices, relations, triggers, and stored procedures, but zero records in each table.
To do the update, I make a copy of the empty database, and then do an APPEND FROM for every table. If there is a referential integrity relationships with "R" (restrict) in the third column, the parent table has to be copied before the child table. (If you don't use referential integrity, you don't need to worry about this.)
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)