Insert Data from SQL Server to MySql using Trigger

Question

I have two databases, one is in SQL Server and other is in MySql. I want to insert data into MySQL table while an insertion occurs in the SQL Server table. Is it possible using a trigger in SQL Server? Please give me an answer?

jsist · Accepted Answer · 2012-10-26 05:08:45Z

4

You can create connection from MSSQL to MySQL by going through this article on connecting MSSQL to MySQL.

After successfully creating connection from MSSQL to MySQL, you can write trigger to insert data in MySQL database using INSERT query in your trigger.

Hope it helps...

answered Oct 26, 2012 at 5:08

jsist

5,2534 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Data from SQL Server to MySql using Trigger

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related