[dba-Tech] database

Ha! (oh dear...)

Can't help you there. Sorry.

- Hans



On 2013-01-26, at 4:40 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> Constraints? What's a constraint? ;-)
> 
> What's all that fancty talk...this database is over twenty years old, there
> was no Oracle, Linux, MySQL etc etc...
> 
> Jim 
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Hans-Christian
> Andersen
> Sent: Saturday, January 26, 2013 4:15 PM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] database
> 
> 
> Does this database have constraints in any shape or form? If the database is
> capable of constraints (most modern databases do, but older ones, I feign
> ignorance) and it was implemented properly, it makes life a heck of a lot
> easier, since you can a quick overview of the relationships between
> different tables - thus making your life easier.
> 
> - Hans
> 
> 
> On 2013-01-26, at 11:28 AM, "Jim Lawrence" <accessd at shaw.ca> wrote:
> 
>> 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
>> 
>> _______________________________________________
>> 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
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com