CODEWITHSUNDEEP
c#sql-serverwinforms
user2255310
user2255310

Reputation: 11

Store in local database when remote SQL Server unavailable and then sync when connected

I am developing a C# Windows Forms app for event management. There will be 15 gates with RFID readers. These readers will read the UID and query the database to check if it is unique entry for that day.

Now if for some reason, SQL Server is not available, I want the app to store the data in a local database and sync as soon as the connectivity is restored.

Any idea on how should I do it?

Thanks

Upvotes: 0

Views: 180

Answers (1)

ErikEJ
ErikEJ

Reputation: 41799

You could use SQL Server replication, and install SQL Server Express with a local copy of the database on each device.

Upvotes: 1

Related Questions