Thank you all for your suggestions. Short description of the system:
- the aim is production tracking
- there are 2 PCs each with its own MS SQL Server and a software that collects production data and feeds its database. Only one pc is active at a time: the other is a hot backup, i.e. powered on, but doing nothing. The database in the hot backup is synchronized by the primary pc using MS Sync Framework
- last but not least the factory has another system running PostgreSQL which must be updated continuously with production data as well.
That's why I was thinking about triggers firing on the primary pc to update PostgreSQL.
What about Service Broker? I could send messages in those triggers and then let a .NET application collect them and feed the Postgre database. Anyone who has esperience of Service Broker?