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 > > > >