Looking 4 Database Data (ex., tax data) Archival Software

> I am searching for software that can aid us in archiving database data. The > archived data will be used for tax and legal purposes. Database backups and > logs are not adequate. We must be able to retrieve the data even if the > database structure changes or the database no longer exists. > > We have currently applications that use SQL Server NT (4.2), Sybase (4.9, > 4.10) on S-v.4, Oracle (7.0, 7.1) on HP-UX and DYNIX (Sequent),and DB2 on MVS. > > One package would be great but I am willing to consider multiple packages. > > Any references to software of this nature is greatly appreciated. > > Regards, > Mike We have been thinking about this for a while, and the simplest solution is the one that seems best. Our plan is to unload data to flat files, and store the schema and the files on optical disk, sorted by date. That way we can re-create the table and load it whenever we want, and will not have to wonder what any particular data item is. This plan is also highly portable, as most any db could be made to read in the files. Please post any other solutions you find, and elaborate on how a given piece of software could stand the long-term changes in db structures and technology. __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|