[dba-Tech] database

Hi Rocky:

Yes, they will have an archive to refer to. 

Much of this planning has been between the owners and the new accountant as
the government wants to do an audit. A businesses' greatest fear...given a
potential law-suit.

It appears the previous owner's books and postings are in direct conflict
with new owners/accountants interpretation of the accounts...so everything
must be squeaky clean and every transaction file (no record created and
saved is ever really removed and any change is carefully recorded in these
hidden transaction files...dates, differences, staff member performing the
task and so on) must correctly cross-reference.

Jim   

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, January 26, 2013 11:18 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] database

I'd archive the entire database so that they could go back and look later if
necessary.  

What is their reason for clearing out everything but the last five years?
But then they want to preserve select records like unpaid invoice and be
able to retrieve that data going back 20 years? 

R

-----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 10:45 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] database

Those were my initial thoughts but then there would be issues with inventory
and the related accounting. 

Then there is the issues with whether a client ever had an unpaid invoice, a
bankruptcy or even association issues that will a have to be rolled forward
and records will still have to be flagged and situations noted. There is
also the thresholds that may establish a client, supplier or even staff as
"rated highly", "to watch" or "do not do business with" as incidents before
the five year cut-off must be carried forward. 

Some inventory has been active for twenty years while other items not...
Then there is the accounting, security and transaction files. Then there are
the issues of how much should be carried forward, in summary files... The
clients still wants to be able to chart activity even though it may have
been rolled up to five years...setting averages, viewing trends,
inventory/equipment quality, and so on.

Then there has been a lot of bad practices, especially in the accounting
where a series of book-keepers were suppose to manage things...now the
company has a real Chartered Accountant...a breathe of fresh air. 

As you are an expert at business practices any thoughts and cautions would
be appreciated?

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, January 26, 2013 10:18 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] database

Modifying the relationships to cascade delete? 

Rocky


-----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 10:02 AM
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

_______________________________________________
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