Syncing access-control devices with the member database

The challenge

Door gates and fingerprint devices (ZK) were isolated islands: authorized-person lists were updated manually, device by device, so they always lagged reality. Someone who had left the institution could still enter for weeks, while a new student waited days for their fingerprint to “reach” the devices — a security gap and an administrative headache at once.

The solution

We built a sync layer running as a permanent Windows service between the database and the devices:

• The SQL Server member database as the single source of truth
• Additions and revocations pushed to ZK devices automatically the moment status changes
• Intelligent handling of outages: retries and queues for pending changes
• Complete audit logs: what changed, when, and on which device
• A monitoring screen showing each device’s status and last successful sync

The outcome

Access permissions now mirror the database within minutes instead of weeks, and management has a full audit trail answering “who could enter, and when?”.