I'm running into a challenge here trying to "sync" a MySQL table with a SQL Server table. My scenario involves my linux-based website submitting form data submissions to a MySQL database on that web server.
What I'm shooting for is to copy any inserts on the MySQL table to the SQL Server table, and I'm not finding a whole lot of support for this. I'm using SQL Server Management Studio and I have my SQL Server database and I've added the MySQL as a linked server.
I had the thought of creating a trigger on that linked server, but it doesn't look like that will work coming from the SQL Server side.
Does anyone have any experience with this? I'm looking for the "best practice" scenario for this type of situation. The syncing between these tables needs to be as close to real time as possible.