Is there a simple way to occasionally archive a few records which may have data in a number of tables to a secondary db which has the same structure as the first? I'd like to be able to move records out of the main db on a regular basis, but not delete them altogether.

Thanks

Why not set up a script to export/import your records?

you can make the script do any looping or other tricks required to export, then import all the records, related records and what-not.

Don