Easy? In a relative way, yes. You can probably set up a test environment
and be ready to experiment in
an afternoon. The challenges, of course, will be specific to your
environment. How much of the data changes over say an hour or a day's
time? Are there primary keys on all of the tables you wish to replicate?
Are you
trying to capture ddl as well as dml? Is the data modified by home-grown
or third party applications? Are
there stored procedures and triggers? What about sequences? Setting
things up might not take too long,
but I would definitely plan for a significant amount of testing time. On
my last project it took less than two
weeks to configure and replicate 20 schema in 7 instances with over a
thousand tables. But because there
was a third party commerce application driving the data changes we let
the replicates run for 3 full months,
until we understood of all of the issues including month-end processing.
The weirdest issue was bad
character set data in a table which was supposedly clean. It would
consistently crash one of the apply
processes, seems developers don't always scrub input data, sigh.
cheers,
j
On 3/23/18 1:51 AM, Chen Zhou wrote:
Thank you all. Are these tools easy to learn? If it takes a few weeks to learn, it won't sell to the management no matter how low the price tag is.
On Thu, Mar 22, 2018 at 4:43 PM, Mladen Gogala <gogala.mladen@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx>> wrote:
And, of course, there is Quest's SharePlex, which is tested and
tried. Also available on the time basis. I've had some experience
with SharePlex few years ago and they were favourable. As for
DbVisit, I have used their standby for standard edition product
and it's an excellent product. It can even do a switchover, just
like DG Broker. If DbVisit replicate product is of the same
quality as their standby product, I wouldn't hesitate to use it.
Regards
On 03/22/2018 04:08 PM, John Kelly wrote:
Chen,
I would add the DBvisit Replicate product to the list. I
believe it is also available on a time basis (you can rent it).
- John Kelly
-- Mladen Gogala
Database Consultant
Tel: (347) 321-1217 <tel:%28347%29%20321-1217>
--
//www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l>
