Hi!
I am trying to replicate 10 tables in MySQL but 3 of the tables does not have PK, so I am going to use KEYCOLS. But I am a little lost on how to configure it.
EXTRACT EXT_PERSON1
SOURCEDB mydb@localhost:3306, useridalias Alias_Red
TRANLOGOPTIONS ALTLOGDEST "/myogg/binlog.index"
EXTTRAIL /myogg/dirdat/ep
TABLE PERSON.TBL1, KEYCOLS (id);
TABLE PERSON.TBL2, KEYCOLS (id);
TABLE PERSON.TBL3, KEYCOLS (id);
TABLE PERSON.TBL4;
TABLE PERSON.TBL5;
TABLE PERSON.TBL6;
TABLE PERSON.TBL7;
TABLE PERSON.TBL8;
TABLE PERSON.TBL9;
TABLE PERSON.TBL10;
Is there a more efficient way?
Thanks!
Gerard