Re: Golden Gate or Logical Standby for Peoplesoft

From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 26 Feb 2014 16:30:43 +0100
Message-ID: <CAJ2-Qb_KYjp-Ln8_JfnA5rOWDa-FXMcq3kjhU6DkwVST-PXMMA_at_mail.gmail.com>

yea but if the application ensure integrity then keycols are not requiered, in fact that would slow down the migration process since you have to involve people from peoplesoft to tell you which columns can be used as potentil keycols candidates

On Wed, Feb 26, 2014 at 4:24 PM, Mohan <moganconsulting_at_msn.com> wrote:

> Hi
>
> GoldenGate has constructs to simulate the existence of a PK or UK via the
> use of "KEYCOLS" during replication setup phase.
>
> Mohan moganconsulting_at_msn.com 732-742-0640
>
> ------------------------------
> Date: Wed, 26 Feb 2014 10:53:53 +0100
> Subject: Re: Golden Gate or Logical Standby for Peoplesoft
> From: exriscer_at_gmail.com
> To: Hemant-K.Chitale_at_sc.com
> CC: oracle-l_at_freelists.org
>
>
> Hi
>
> I dont have exp with Logical Standby but have use GoldenGate for several
> migrations.
>
> GoldenGate can handle tables with no PK or FK, not recommendable but it
> works, what it does is it uses all columns as PK when there is no PK
> defined. As long as the application handles correctly referential integrity
> GoldenGate is ok
>
>
> Regards
>
>
>
>
>
> On Wed, Feb 26, 2014 at 4:05 AM, Chitale, Hemant K <
> Hemant-K.Chitale_at_sc.com> wrote:
>
> Has anyone done GoldenGate or Logical Standby setup for an **entire**
> Peoplesoft (Financials) Schema ?
>
> Peoplesoft doesn't have PK and FK definitions and Referential Integrity
> constraints. Would GG / LS be doable ?
>
> Hemant K Chitale
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 26 2014 - 16:30:43 CET