John Bartow
john at winhaven.net
Sat Jan 26 12:20:36 CST 2013
Isn't that a great use for enforcing relational integrity via the DB engine? -----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 12:02 PM 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