Backing up databases  
Author Message
mhust6





PostPosted: 2005-6-17 5:49:00 Top

java-programmer, Backing up databases I am looking to write some basic scripts to back-up various files and
databases as well as restore them. Do you think this would be easier
and better to do using Ant or Ruby?

I would appreciate any insight available.

Thanks!

 
David Harper





PostPosted: 2005-6-17 13:57:00 Top

java-programmer >> Backing up databases email***@***.com wrote:
> I am looking to write some basic scripts to back-up various files and
> databases as well as restore them. Do you think this would be easier
> and better to do using Ant or Ruby?
>
> I would appreciate any insight available.

That's a rather vague question, and you're unlikely to get any useful
advice unless you give a little more detail, such as:

1. What database system are you using? Oracle? MySQL? PostgreSQL?

2. What operating system? Windows? Linux?

3. Can you afford for your database system to be offline for a brief
period each day, or do your users expect it to be available 24 hours a
day, 7 days a week?

These are all essential questions when planning a backup strategy,
regardless of the language you choose to use.

David Harper
Cambridge, England