It is possible to way I may have a constant update of my SQL Server data seeing a MySQL database?

Just how large of the delay is appropriate will pretty much advice the type of solution you utilize.

  • Updates have to be (near) real-time: you have to either (a) have whatever is pushing the information to MSSQL also push to MySQL simultaneously, or (b) use replication to get it done
  • Updates could be postponed some time: then rather than attempting to replicate things you may make it into an ETL process, where you've got a couple of options, the very best of that is most likely using SQL Server Integration Services (SSIS) where one can design ETL packages to complete the push in whatever way you would like