Jim Lawrence
accessd at shaw.ca
Sat Jan 26 13:09:57 CST 2013
The simple answer is yes and no... I have answered more fully in a response to Rocky's similar comment. If you have any comments or words of wisdom or experience they would be appreciated. I am still carefully going over the batch files (each component has been tested and re-tested over the last couple of months) and have been adding exception code when required. The process file is a few thousand lines of code and the real processing can not start until after the business has closed, at 5:00PM and the backups have been run. After that, with any sort of luck the batch will crunch away for next 24 to 36 hours or so...requiring no human intervention. The data has to be first cleaned, accounts balanced even before the roll-ups starts. After all the processes have been successfully completed, then the remaining data will be exported, the tables will be cleared of data, the data files keys will be removed, the data will then be imported, the keys will then be re-added and the counter numbers be set to the appropriate start values. In the highly unlikely even that anything goes wrong (yeah, right), I have set the system to automatically call my cell, hopefully providing the appropriate error messages. I have done many such systems over the years but never done one with so many years of data or for that matter so complex. I plan to sleep again on Monday. ;-) Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Saturday, January 26, 2013 10:21 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] database 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 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com