MySQL trigger to update SQL Server table

Question

Is it possible to update a table in SQL Server using a trigger in MySQL. The scenario is like this.

When a table is updated in MySQL, a corresponding update is to be done in SQL Server for the purpose of syncing certain fields. I understand that the reverse is possible using a linked server in SQL Server.

Devart · Accepted Answer · 2012-02-23 14:36:58Z

3

You can write a UDF function that would update data in the SQL Server. Then call this UDF from the trigger.

answered Feb 23, 2012 at 14:36

Devart

120k23 gold badges172 silver badges189 bronze badges

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

2 Comments

Vimal Raj Over a year ago

Is it possible for the MySQL UDF to update the SQL Server table.

Devart Over a year ago

UDF allows to use C++ code. I think you will find many examples in the internet (e.g. c++ how to connect to sql server).

Simon at The Access Group · Accepted Answer · 2012-02-23 14:22:49Z

-1

Here's some information which may be of help regarding linking SQL Server and MySQL

http://forums.mysql.com/read.php?60,123221,123221

I'm afraid I've no personal experience in the matter as I thankfully have MySQL servers across the board, however had a scan through the links in the above and at least one of them should be able to assist.

answered Feb 23, 2012 at 14:22

Simon at The Access Group

7,0251 gold badge25 silver badges47 bronze badges

Collectives™ on Stack Overflow

MySQL trigger to update SQL Server table

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related