wanted : archive tool

From: fhoornaert_at_hotmail.com <(fhoornaert_at_hotmail.com)>
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 Hoornaert
Received on Thu Jan 29 2004 - 15:47:39 CET

Original text of this message