wanted : archive tool
Date: 29 Jan 2004 06:47:39 -0800
Message-ID: <9ce3481b.0401290647.4a005655_at_posting.google.com>
Hello,
[Quoted] I'm looking for a reliable software solution for archiving a production database to a backup database.
the main goal of the archiving tool :
Without archiving, the production database would have a total of 100Gb/year
over 300 tables.
[Quoted] The customer only wants the data of the last 3 months in the production
database so that it can be easily backup each night.
Data older then 3 months should be transferred once a month to an archive
database.
This archive database should have the same structure as the production
database and should also be on-line 24h a days.
Data in the archived database should be kept for 30 years.
We have a lot of administration tables (250 out of 300) which are only
updated, no records are added. The other 50 tables (used for registrations)
have lots of inserts in them.
[Quoted] The administration tables should be synchronized from the production DB to
the archive DB, while the registration tables should be transferred based on
a date.
[Quoted] Which are the possibities ? Any good 3rd party solutions ? And without 3rd party solution ?
When replying, please CC to my email account
-- Greetz, Frederic HoornaertReceived on Thu Jan 29 2004 - 15:47:39 CET