4 ms·
Genuinely curious how it's possible to port things like triggers from one engine to the next, when they may have fundamentally different syntax and semantics.
by apetresc 11y ago
Genuinely curious how it's possible to port things like triggers from one engine to the next, when they may have fundamentally different syntax and semantics.
- cbsmith 11y agoThat's been a "thing" for a while now. It's tricky, has some rough edges, but doable.
- apetresc 11y agoNeat. How does it work? Like, do they compile one system's triggers to some sort of intermediate language, and then compile that back to the target system's language? Does the resulting code resemble something a human would write?
- cbsmith 11y agoIt's a combination of that (usually the intermediate language is ANSI SQL) and also used stored procs & UDT's to provide "work alike" behaviors.