goldengate sqlserver mysql_GoldenGate实现oracle和sqlserver双向数据同步（转载文章，结合我的另一篇文章实验可行）...

本文记录了配置oracle和sqlserver数据同步的关键步骤，只为备忘！

测试环境：

oracle10.2.0.1

sqlserver2005(SQLServer2005SP3-KB955706-x86-CHS.exe)

oracle->sqlserver同步：

oracle和sqlserver中分别建一张测试表(表必须有主键)

oracle:create table n (id number(10) primary key)

sqlserver:create table n (id int primary key)

oracle:

ggsci>edit param mgr

port 7809

ggsci>dblogin userid ggs,password ggs

ggsci>add trandata test.n

ggsci>edit param eiexaa

extract eiexaa

userid ggs,password ggs

exttrail ./dirdat/dd

table test.n;

ggsci>edit param epmpaa

extract epmpaa

passthru

rmthost 192.168.126.131,mgrport 7809

rmttrail ./dirdat/dd

table test.n;

ggsci>add extract eiexaa,tranlog,begin now

ggsci>add exttrail ./dirdat/dd,extract eiexaa,megabytes 5

ggsci>add extract epmpaa,exttrailsource ./dirdat/dd

ggsci>add rmttrail ./dirdat/dd,extract epmpaa,megabytes 5

sqlserver:

ggsci>edit param mgr

port 7809

ggsci>dblogin sourcedb ggsdb userid ggs,password ggs

(ggsdb为系统DSN名)

ggsci>edit param rorabb

replicat rorabb

sourcedb ggsdb userid ggs,password ggs

handlecollisions

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/rorabb.dsc,PURGE

map test.n, target n;

ggsdb数据库创建ggs_checkpoint表

ggsci>add replicat rorabb,checkpointtable ggs_checkpoint,exttrail ./dirdat/dd

sqlserver->oracle同步：

oracle和sqlserver中分别建一张测试表(表必须有主键)

oracle:create table m (id number(10) primary key)

sqlserver:create table m (id int primary key)

sqlserver:

ggsci>sourcedb ggsdb dblogin userid ggs,password ggs

ggsci>add trandata m

ggsci>edit param eiexbb

extract eiexbb

sourcedb ggsdb userid ggs,password ggs

exttrail ./dirdat/bb

TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT

table m;

ggsci>edit param epmpbb

extract epmpbb

passthru

rmthost 192.168.126.1,mgrport 7809

rmttrail ./dirdat/bb

table m;

ggsci>add extract eiexbb,tranlog,begin now

ggsci>add exttrail ./dirdat/bb,extract eiexbb,megabytes 5

ggsci>add extract epmpbb,exttrailsource ./dirdat/bb

ggsci>add rmttrail ./dirdat/bb,extract epmpbb,megabytes 5

oracle:

ggsci>dblogin userid ggs,password ggs

ggsci>edit param roradd

replicat roradd

userid ggs,password ggs

handlecollisions

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/roradd.dsc,PURGE

MAP dbo.m, TARGET test.m;

ggs用户下创建ggs_checkpoint表

ggsci>add replicat roradd,checkpointtable ggs.ggs_checkpoint,exttrail ./dirdat/bb

标签：