Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Replication between MSSQL 2005 and MySQL

2 views
Skip to first unread message

Dejan Markic

unread,
Apr 20, 2006, 6:45:28 AM4/20/06
to
Hello all!

Is it possible to replicate table from MSSQL 2005 to MySQL?
I have one table, which I would like to replicate to MySQL, but I don't see
the option to do that ... is it not possible?!

Thanks for all your input.

Kind regards,
Dejan


Hilary Cotter

unread,
Apr 20, 2006, 7:18:19 AM4/20/06
to
There were some issues with this in SQL 2000. Basically it would run
gangbusters until the distribution agent stopped and then you would have to
resynchronize to start it up again. To do this in SQL 2005 you need follow
the instructions in

How to: Create a Subscription for a Non-SQL Server Subscriber (Replication
Transact-SQL Programming) in BOL.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Dejan Markic" <de...@akton.is> wrote in message
news:bDJ1g.1942$oj5.7...@news.siol.net...

0 new messages