Dudes,

I have this customer who is interested to replicate a SQL Server 2005
database to a MySQL database, online... For example, you insert a record to
the SQL Server and it automatically inserts it on the MySQL database. Both
has the same schema. They are on a LAN or VPN.

I just need an idea on how you would solve this...

Cheers!

Officially this is not supported on SQL 2005. You can try to add an ole-db
provider to MySQL and create it as a subscriber that way.

--
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



[quoted text, click to view]