I would like to be able to copy a few tables (some in a relationship) from time to time and then restore the state from the copies.
To save the tables
insert into _newtable_ from _oldtable_
works nicely. But to recopy into the orignal tables seems to be tricky, due to identity, foreign keys etc.
Is there a simple way to do this? (copy with production :) )
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.