[dba-Tech] database

Hi Tina:

Hardly simple minded but there are issues, in this case with straight "
enforce referential integrity ". It is more thoroughly explained in a
previous post. 

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Saturday, January 26, 2013 11:00 AM
To: Discussion of Hardware and Software issues
Subject: Re: [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
>

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