Archieving Data on a Progress V8 database
- Thread starter Hillary
- Start date
philippoommen1
Member
Hello,
Usually we are keeping Date & Time(hh:mm:ss) fields aloing with every records & Simply using the FOR EACH statements along
with an appropriate WHERE clause on the FOR EACH statement.
Obviously, the WHERE clause can be as simple or complex as needed. Backup the database be taken before Archieving records just in case records are removed that should not have been
removed.
I have no idea abt progress has a DB Admin utility to do this Archieving
Regards
Philip
Usually we are keeping Date & Time(hh:mm:ss) fields aloing with every records & Simply using the FOR EACH statements along
with an appropriate WHERE clause on the FOR EACH statement.
Obviously, the WHERE clause can be as simple or complex as needed. Backup the database be taken before Archieving records just in case records are removed that should not have been
removed.
I have no idea abt progress has a DB Admin utility to do this Archieving
Regards
Philip
TomBascom
Curmudgeon
There is no generic utility to archive data. Archiving is a business process that is generally subject to business rules regarding which data in which tables should be archived. (The rules might be as trivial as "all data in all tables with a timestamp of such and such" -- but the rules are still there and important to define.) You also have to consider how you plan to maintain and access the archive and the application code needed to understand it.
Personally I generally consider archiving to be a waste of time and effort. You're just moving bits around, adding overhead and creating additional potential points of failure.
Purging, on the other hand, makes a certain amount of sense because not all data should be kept forever. You still need business rules that define what data should be destroyed and when but at least you don't have to manage it and arrange to be able to access it ever again. Then again really and truly destroying data is more difficult than it might seem.
Personally I generally consider archiving to be a waste of time and effort. You're just moving bits around, adding overhead and creating additional potential points of failure.
Purging, on the other hand, makes a certain amount of sense because not all data should be kept forever. You still need business rules that define what data should be destroyed and when but at least you don't have to manage it and arrange to be able to access it ever again. Then again really and truly destroying data is more difficult than it might seem.
Would you know the utility? I want to archieve by transaction entry date. the other difficulty that I am likely to face is accessing that data. Regards
TomBascom
Curmudgeon
There is no such Progress utility.
If you are running an application which you purchased then your vendor may have provided such a utility that is specific to their application. You should check with them (or their documentation), or post in the appropriate vendor's forum, if that is the case.
If you are running an application which you purchased then your vendor may have provided such a utility that is specific to their application. You should check with them (or their documentation), or post in the appropriate vendor's forum, if that is the case.