Replication from MS SQL 2005 to MySQL 5.1

Question

Post reply

Replication from MS SQL 2005 to MySQL 5.1

M Chapman

SSC Veteran

Points: 242
More actions
December 27, 2006 at 8:16 am

#193556

Is there anyone out there that knows how to use replication from SQL 2K5 to MySQL?
I cannot find anything out there, and its driving me insane.
Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

Check BOL...

How to: Create a Subscription for a Non-SQL Server Subscriber (Replication Transact-SQL Programming)

http://msdn2.microsoft.com/en-us/library/ms146961.aspx

MohammedU
Microsoft SQL Server MVP

Robert Davis One Orange Chip Points: 28027 More actions · Answer 2

The only non-SQL Server database systems supprted are Oracle and DB2. SQL Server does not support replication to or from MySQL.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

M Chapman SSC Veteran Points: 242 More actions · Answer 3

Thanks guys!

I didn't think this was possible...if I find anything out, I'll post it somewhere.

MohammedU SSCoach Points: 19644 More actions · Answer 4

Looks like it is possible.. see the following thread replied by Hilary who is one of the sql server MVP AND coauthor of one of the replication books...

http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/9a35d82c1bf7509b/e35653fa4546b5f4?lnk=st&q=replication+from+sql+server+to+mysql&rnum=5#e35653fa4546b5f4

http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/1aac4ac36a94cc95/55eec14ec5ea02ea?lnk=st&q=replication+from+sql+server+to+mysql&rnum=3#55eec14ec5ea02ea

MohammedU
Microsoft SQL Server MVP