We have an in-house data replication process - ADABAS to SQL making use of PLOG data.
Currently has a trial of Event Replicator.
One question, on Mapping tools :? :?
Our SQL tables currently have Primary keys which consist of multiple fields from the table (as per super descriptors in ADABAS).
When we are mapping the files, we have the ability to set multiple fields as keys, but only one as the Primary key. We need to be able to set multiple fields as “Primary key”, with a sequence of the fields within the primary key. We use this to maintain our data integrity.
An example of this is our Customer table, where the key is created as the Company Code and the Customer number.
ALTER TABLE DFS_CUSTOMER WITH NOCHECK
ADD CONSTRAINT [PK_DFS_CUSTOMER] PRIMARY KEY CLUSTERED
( [CUST_NO], [CPNY_CODE] ) ON [PRIMARY]
How do we go about this?