We have a website that stores form data in a web hosted MySQL database. Whenever form data is entered into the MySQL server tables I need update all necessary tables on our local SQL Server database.
I have seen several articles that describe how to update MySQL using SQL Server triggers but nothing that goes the other way.
If I create a linked server and linked tables in SQL Server can I create a trigger on a MySQL table from the SQL Server management studio?