0

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.

closed as unclear what you're asking by Paul White, billinkc, Colin 't Hart, RLF, Philᵀᴹ Feb 28 '15 at 20:07

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Since when does MySQL have a CLR (.NET runtime)? – TomTom Feb 24 '15 at 9:04
  • A UDF library with functions to interact with the operating system. These functions allow you to interact with the execution environment in which MySQL runs. I am trying to call external dll in mysql. Please go through this article.crazytechthoughts.blogspot.in/2011/12/… – Musakkhir Sayyed Feb 24 '15 at 9:19
3

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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.