Replication

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
"Christian Strevel (Intellekt)" <cs@.prodigy.net.mx> wrote in message
news:u9UrgXw7GHA.1012@.TK2MSFTNGP05.phx.gbl...
> 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!
>