Re: Golden Gate or Logical Standby for Peoplesoft

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Mohan <moganconsulting@xxxxxxx>
  • Date: Wed, 26 Feb 2014 16:30:43 +0100

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@xxxxxxx> 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@xxxxxxx 732-742-0640
>
> ------------------------------
> Date: Wed, 26 Feb 2014 10:53:53 +0100
> Subject: Re: Golden Gate or Logical Standby for Peoplesoft
> From: exriscer@xxxxxxxxx
> To: Hemant-K.Chitale@xxxxxx
> CC: oracle-l@xxxxxxxxxxxxx
>
>
> 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@xxxxxx> 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
>
>
>
>

Other related posts: