[Solved] Remote and local databases in C# [closed]

Question

You should probably look at message queues (the Microsoft version is called MSMQ and is built into Windows. Other message queues are available). They are designed for exactly this sort of scenario.

Essentially, your application write an event to it’s local message queue. This will attempt to send it to the remote queue (on the database in this case) periodically, providing for reliable message delivery.

On the database queue you typically have a listener watching the queue and writing any events it receives to the database.

Accepted Answer

You should probably look at message queues (the Microsoft version is called MSMQ and is built into Windows. Other message queues are available). They are designed for exactly this sort of scenario.

Essentially, your application write an event to it’s local message queue. This will attempt to send it to the remote queue (on the database in this case) periodically, providing for reliable message delivery.

On the database queue you typically have a listener watching the queue and writing any events it receives to the database.