Gustav Brock
Gustav at cactus.dk
Sat Jan 26 12:49:31 CST 2013
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