[dba-Tech] database

Okay, first I would make a copy of the database as it stands, now.  That 
would be my backup for safekeeping.

Then, couldn't you enforce referential integrity and enable cascade delete?

Or, am I being too simple-minded?  I do that, sometimes.  :-)

T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787

On 1/26/2013 1:02 PM, Jim Lawrence wrote:
> 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
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>