goldengate sqlserver mysql_Oracle GoldenGate 之 SqlServer数据同步到Mysql数据库

C:\OGG>INSTALL ADDSERVICE

Service 'GGSMGR' created.

Install program terminated normally.

C:\OGG>

配置ODBC数据源Microsoft SQL Server ODBC 驱动程序版本 06.01.7601

数据源名称: oa_test

数据源描述:

服务器: WIN-UGCMTTOTKE7

数据库: (Default)

语言: (Default)

翻译字符数据: Yes

日志长运行查询: No

日志驱动程序统计: No

使用区域设置: No

预定义的语句选项: 在断开时删除临时存储过程

使用故障转移服务器: No

使用 ANSI 引用的标识符: Yes

使用 ANSI 的空值，填充和警告: Yes

数据加密: No

配置OGG抽取进程GGSCI (WIN-UGCMTTOTKE7) 8> dblogin sourcedb oa_test,userid yunwei,password "********"

2014-07-21 14:39:28 INFO OGG-03036 Database character set identified as windows-936. Locale: zh_Hans_CN

2014-07-21 14:39:28 INFO OGG-03037 Session character set identified as GBK.

Successfully logged into database.GGSCI (WIN-UGCMTTOTKE7) 12> add trandata dbo.TEmployees2014-07-21 14:43:51  WARNING OGG-01483  The key for table [oa_test.dbo.TEmployees] contains one or more variable lengthcolumns.  These columns may not have their pre-images written to the transaction log during updates.  Please use KEYCOLS to specify a key for Oracle GoldenGate to use on this table.Logging of supplemental log data is enabled for table dbo.TEmployeesGGSCI (WIN-UGCMTTOTKE7) 13> add trandata dbo.TRecords2014-07-21 14:46:04  WARNING OGG-01483  The key for table [oa_test.dbo.TRecords] contains one or more variable length columns.  These columns may not have their pre-images written to the transaction log during updates.  Please use KEYCOLS to specify a key for Oracle GoldenGate to use on this table.Logging of supplemental log data is enabled for table dbo.TRecordsGGSCI (WIN-UGCMTTOTKE7) 14> edit params oa编辑如下内容：defsfile c:\ogg\dirdef\oa.defsourcedb oa_test,userid yunwei,password "******"table dbo.TEmployees;table dbo.TRecords;执行生成表结构定义文件C:\OGG>defgen paramfile c:\ogg\dirprm\oa.prm将新生成的def文件拷贝到目标端！