Is it possible to insert data in MySQL from a SQL Server trigger?

Question

A fun question for a Friday afternoon, no?

As the question states, is it possible to write a SQL Server trigger that inserts data into a MySQL table?

---

EDIT: Yes, I know this is basically a dumb idea and that the application should be doing it and so on. But this is a legacy Classic ASP application which we're transitioning to MySQL; and until we get rid of the ASP bit we really would like to be able to squirt data over to the MySQL system without touching the ASP code.

For there be dragons. Just mentioning it tends to make it crash.

Thanks all!

Answer 1

In order to write data to a different database from SQL Server, you'd have to first create a linked server instance on SQL Server pointing to the other db (MySQL in this example) with appropriate credentials/permissions.

Answer 2

One way to do this would be to use SQL CLR. You could have a CLR stored procedure or function that accesses the MySql DB.