[dba-Tech] database

Hi Gustav:

I do have incredible confidence in you guys.

It never hurts to be a little overly cautious with these sort of events and
who knows, there may be a obvious "got-ya" that I have over-looked. 

Jim 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, January 26, 2013 10:50 AM
To: dba-tech at databaseadvisors.com
Subject: Re: [dba-Tech] database

Hi Jim

I must say you have great confidence in us. After a couple of months'
planning you ask for good advice within the hour!

That said, and as already mentioned, I would certainly look for setting
cascade deletes.

/gustav

>>> accessd at shaw.ca 26-01-13 19:02 >>>
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