How can I sync my MSSQL database to MySQL?

I am using MSSQL as my transactional database. This database has 200+ tables with about 25 tables that hold 1M plus records. I want to replicate the data with the same st开发者_开发问答ructure into a MySql database for reporting. Is there a tool or method that can do this in a fairly real time manner?

Use SQL Server's Linked Server to access MySQL from SQL Server.