Can we call SQL CLR in MySQL Server using User Define Function?
I want to create trigger in mysql. It will call user define function and this UDF will update the table in SQL Server.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Yes you can. Or no you can't. It doesn't really matter. If you think about how DBMS1 is going to have to deal with a commit and/or rollback after it has, via your UDF function in which you have hidden an update to another, external, DBMS2, then you should realize that this is a very bad idea no matter how you toss or turn it, because somwewhere somehow it is going to happen that an update transaction has gone non-ACID-compliant.