There is a dedicated factory control program that is in use with MSSQL Server 2012?, and is developed for it - and there is no room for further development.
Now, this factory control program is sending data to MSSQL all the time.
I want to trigger the insert and make it shoot a value that is inserted into another DB-InfluxDB.
I mean...
----Suspicious section of whether the right idea is coming from here----
I want to call an external program by putting an insert trigger on the table that received the existing value.
The external program is now envisioning a socket that shoots a structure with its specific port at the values received by MSSQL (about 10 variables).
The port has a program that receives the structure and shoots it into the InfluxDB.
You might think that the program that shoots at MSSQL should be put on InfluxDB, but we haven't reached that stage yet. I can't do ActiveX....
I've been looking through this and that
You can make a job in MSSQL run an external program I don't think it's connected to the trigger? CmdExec adds something to the job, but it's not a trigger...
Is there a way?
mssql trigger
You can invoke web services using MSXML2.XMLHTTP in the procedure.
You can invoke procedures at the time of an event (trigger) and call web services from other systems within the procedure.
Of course, in this case, transaction processing is not possible, so synchronization of both DBs can be a problem.
© 2024 OneMinuteCode. All rights reserved.