Making a copy of a database for query\reporting

george white

Making a copy of a database for query\reporting
Hi,

I'm interested in anyone's experiences in creating a duplicate copy of a
database.

We currently use unload\load for smaller databases. But, I am now asked to do
the same for a larger DB.

o Does anyone have experiences they can share regarding IBM's Data Propagator
Capture-Apply?

o How about BMC's Change Data Capture or others?

What other products are out there?

Is there a solution that relies on off the shelf products and techniques?


I'll appreciate all replies.

Thanks, George White.