RE: Oracle migration using shareplex or goldengate or TTS
- From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
- To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>, "haroon.qureshi@xxxxxxxxx" <haroon.qureshi@xxxxxxxxx>
- Date: Tue, 18 Jun 2013 20:04:52 +0100
Two good answers so far, both coming down on the side of GG over TTS.
My two pennies worth is that for all the difficulties of TTS I would prefer the
consistency of taking a full tablepace(s) across intact and knowing no rows
could be missing or out of sync. Factor in that TTS does not cost anything
extra then it seems a no brainer.
However if you have to have no outage migration (which is not what the op
needed) then TTS is no use and GG/Shareplex is the tool of choice.
I have used Shareplex in the past for a migration and it was a good tool. I am
sure GG (which we use but not for migrations) is just as good.
John
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ls Cheng
Sent: 16 June 2013 10:47
To: haroon.qureshi@xxxxxxxxx
Cc: oracle-l
Subject: Re: Oracle migration using shareplex or goldengate or TTS
Hi
I have had experience with OGG, very good, virtually no downtime (in my
case was aprox 5 to 10 minutes in several migrations). You dont need as
much as preparation as TTS but there are preparations specially migrating
from old 9i to latest versions.
But you need a lot of $$$ to buy OGG because you have to license both
source and target systems. I have a few customers had to use other ways
such as TTS because of the license costs, you cannot buy OGG just for
migration purposes, if the customer cannot find a use for OGG after the
migration then they need to seriously considering if it's worth it.
Thanks
--
LSC
--
//www.freelists.org/webpage/oracle-l
______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The
registered office of the company is situated at Gain Lane, Bradford, West
Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to
the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or rely
on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the
Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to
time, apply to any contract that we enter into. The current version of our
Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility,
and it is the responsibility of recipients to carry out their own virus checks.
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
