Replication MYSQL

dataservices job design
1

Hi,

We are trying to achieve data replication using Data Services XI 3.1. The
source database is MySQL 5.1 and destination is SQL Server 2008. The basic idea is MySQL Data replication uses Binary logs sync between source
master mysql and destination slave mysql. However doing the same using
mysql and sql server 2008 is not out of the box and needs customization.I was wondering if we could use Data services to achieve data
replication some way.

Environment: Data Service,SQL Server 2008, MYSQL 5.1
Source :MySQL 5.1
Target : SQL SERVER 2005/2008
Thanks
Grace

Grace (BOB member since 2004-06-09)

2

DI/DS is not really a database replication tool. If there were CDC support for MySQL (there isn’t), you could sort-of do this kind of replication.

There are products out there designed explicitly to replicate data between heterogeneous databases. GoldenGate is one example. But I don’t think it supports MySQL. Database replication tools are usually expensive products used by large organizations, and that’s not always compatible, in market terms, with commercial add-ons to open source tools.

dnewton :us: (BOB member since 2004-01-30)