[dba-Tech] database

Today and tomorrow I will be working on a huge database.

It has records going back to the late eighties and the client wants the
whole system cleared except for the last five years. Clearing data is not
difficult but leaving no orphaned records is. There are over a hundred
inter-related tables and I have been planning this with the client for a
couple of months and today is the day (the company's year-end).

Has any one else had similar experiences and any insights, recommendations
and so on?

Jim