Ask the Expert

Selecting database archiving tools

What factors should I take into consideration when selecting database archiving tools?

Requires Free Membership to View

The type of data stored in the database and the business drivers for archiving have a definite influence on the tool selection criteria. If database tables are being archived to keep the database "lean and mean" for performance reasons but archived data still needs to be accessed occasionally, you probably want to look at a solution that is as seamless as possible. This means that the archived data can be transparently accessed or queried without requiring special manipulation or restore operation.

If data is archived based on an ILM policy because it no longer accessed but must be kept to meet certain legal requirements, a more basic package-based archival tool can be considered. However, you must carefully consider your ability to access the data in the future. Database independent, data extraction and content management tools might be better suited for very long-term archives. This helps ensure data access without depending on a RDBMS version that is no longer available.

Finally, one feature that is worth considering is the DB archiving tool's ability to integrate with a backup solution. This can offer simplified, centralized data management.

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: