I've been asked to integrate SQL transaction data with a video monitoring system in real-time. The video system's application is only capable of receiving data by listening on a serial port or a specific IP address and port.
Is it possible to write/send data from SQL to a serial port or IP? How?
The transaction data is stored in a Microsoft SQL Server 2005 database.
I can't find anything around this on Google or this site. Every search returns how to pick up data from serial and write to SQL dbs, not the other way around.
I may be going around this the wrong way - any related relevant ideas are welcomed.