Laura Oliver
|
I am trying to get rid (archive, purge etc) to make everyday use of DBA faster. I would appreciate any hints. Heres what I have done so far: 1) made two new companies which are exact replicas of the DBA we have used everyday since 1997/ a) named one company (#57) "BUP 1997-2012" b) named the 2nd copy (#12) "Dixie Precision 2012" 2) changed all users to where they all have access to company #12. but or course I have access to #12 and #57 3) my goal is to archive or purge all data in company #12 that is before Jan 1, 2010 (this way my folks are wading thru 3 yrs of data rather than 15 years of data. I am still in the middle of this process, as I have only archived 18,000 work orders and purged some closed sales orders. I plan on using archiving and purging everything I can during this next month. I am looking for any help, ideas, hints , warings, etc. Thanks, Laura
|