windows goldengate配置

1.源端配置：
CREATE subdirs

EDIT param mgr
port 7809

start mgr

info mgr

配置所要复制表的附加日志：
dblogin userid goldengate,password goldengate
info trandata ggs.*;
add trandata  ggs.*;

ADD EXTRACT ext1,TRANLOG,BEGIN NOW

EDIT PARAM ext1

extract ext1
userid goldengate,password goldengate
rmthost 127.0.0.1, mgrport 7809
rmttrail f:\goldendate\dds\dirdat\rr
dynamicresolution
table ggs.tcustord;

通过以下命令添加远程队列：
ADD rmttrail f:\goldendate\dds\dirdat\rr,extract ext1,megabytes 100

ADD replicat rep1,EXTTRAIL f:\goldendate\dds\dirdat\rr,NODBCHECKPOINT

EDIT param rep1

replicat rep1
userid goldengate,password goldengate
assumetargetdefs
discardfile f:\goldendate\dds\dirrpt\rep1.dsc,append
map ggs.tcustord, target ggt.tcustord;