[dba-Tech] database

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