联系：手机(13429648788) QQ(107644445)
链接：https://www.orasos.com/goldedgate-%e5%88%9d%e5%a7%8b%e5%8c%96%e6%95%b0%e6%8d%ae.html
作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
一、mysql数据库初始化
1、source端配置
ADD EXTRACT EINI1, SOURCEISTABLE EDIT PARAMS EINI1 EXTRACT EINI1 sourcedb test@localhost:3306,USERID root, PASSWORD xifenfei RMTHOST 192.168.1.111, MGRPORT 7808 RMTTASK REPLICAT, GROUP RINI1 TABLE "test.web_statistics";
3、target端配置
ADD REPLICAT RINI1, SPECIALRUN EDIT PARAMS RINI1 REPLICAT RINI1 ASSUMETARGETDEFS DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306 TARGETDB test,userid root,password xifenfei DISCARDFILE ./dirrpt/RINI2.dsc, PURGE MAP "test.web_statistics", TARGET "test.web_statistics";
3、开启复制
start extract eini1
二、oracle数据库
1、source端配置
ADD EXTRACT EINI1, SOURCEISTABLE EDIT PARAMS EINI1 EXTRACT EINI1 SETENV (NLS_LANG =AMERICAN_AMERICA.UTF8) USERID ogg, PASSWORD "xifenfei" RMTHOST 192.168.1.111, MGRPORT 7809 RMTTASK REPLICAT, GROUP RINI1 TABLE chf.init_obj;
2、target端配置
ADD REPLICAT RINI1, SPECIALRUN EDIT PARAMS RINI1 REPLICAT RINI1 ASSUMETARGETDEFS SETENV (NLS_LANG =AMERICAN_AMERICA.UTF8) USERID ogg, PASSWORD xifenfei DISCARDFILE ./dirrpt/RINI1.dsc, PURGE MAP chf.init_obj, TARGET chf.init_obj;
3、开启复制
start extract eini1
