Re: Database migration options

From: Arjen Visser <arjen.visser_at_gmail.com>
Date: Fri, 23 Mar 2018 19:20:16 +1300
Message-Id: <85DE1B08-0D39-41C1-8E15-E93116191701_at_gmail.com>



Some tools are easier to learn than others, but in my experience the most difficult thing to grasp for DBAs are the concepts behind logical replication. Logical replication is the process that all these tools use and it is VERY different to physical replication that Data Guard uses and that we all understand. If you do not understand logical replication and the implications of it, a big mess will be created even if you know the tool really well. So make sure you understand the concepts. It is not hard, you just have to know them.

Regards Arjen Visser

> On 23/03/2018, at 6:51 PM, Chen Zhou <oracle.unknowns_at_gmail.com> 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_at_gmail.com> 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
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>

>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 23 2018 - 07:20:16 CET

Original text of this message