 <p>I have used linked servers as a way of sharing data between mysql and SqlServer and then have triggers from the sqlServer to the mysql linked server.</p> <p>if the triggers will not work for you, the other better option will be to setup replication between the sqlserver and the mysql linked server.</p> <p><a href="http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/" rel="nofollow">http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/</a></p> <p><a href="http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/" rel="nofollow">http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/</a></p>