RE: Golden Gate or Logical Standby for Peoplesoft

From: David Kurtz <info_at_go-faster.co.uk>
Date: Wed, 26 Feb 2014 16:48:15 -0000
Message-ID: <00ae01cf3312$8ba26f60$a2e74e20$_at_go-faster.co.uk>

PeopleSoft has unique key indexes. Most of the columns are not null, and providing you don't have a descending column in the unique index, you could create a primary key using the unique key.

You could also set _IGNORE_DESC_IN_INDEXES and rebuild the unique indexes with descending columns. Then you could create primary keys for all tables with unique keys.  

PeopleTools has its own data dictionary from which you can obtain all this information.  

regards

---

David Kurtz
tel: +44 (0)7771 760660
mailto:david.kurtz_at_go-faster.co.uk    

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ls Cheng
Sent: 26 February 2014 15:31
To: Mohan
Cc: Hemant-K.Chitale_at_sc.com; oracle-l_at_freelists.org Subject: Re: Golden Gate or Logical Standby for Peoplesoft Importance: High  

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 - 17:48:15 CET