[dba-Tech] database

Modifying the relationships to cascade delete? 

Rocky


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Saturday, January 26, 2013 10:02 AM
To: 'Discussion of Hardware and Software issues'
Subject: [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

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com