What is the recommended, most reliable and most easily developed solution for archiving old data?
I want my application periodically archive old data from various tables.

I thought to create external tables and use SP to write data there.
This way users can have access to older data also with other tools and my GDB file would also be smaller.
HOw does this solution survive backup restore?

Other thought was to have duplicate database and pump data there.

Or are there better solutions?

Riho-Rene Ellermaa
senior programmer
Hansabank