Distributed Database Synchronization

SyncNaus is a secure database synchronization platform that enables remote clients to pull data from a central database. Each client manages its own local database and pulls incremental updates on demand.

How It Works

1. Register and login to your admin account
2. Add database connection details (credentials are encrypted and stored securely)
3. Deploy the SyncClient to your remote location
4. The client automatically pulls incremental data based on tracking ID
5. Data is inserted only if it doesn't already exist; existing records are updated if newer
6. Monitor sync progress and status from the admin dashboard

Key Features

• ✔ Clients pull only new/updated records based on tracking ID
• ✔ AES-256 encryption for all connection credentials
• ✔ Host whitelist validation for authorized databases only
• ✔ Real-time sync progress monitoring and status tracking
• ✔ Transaction-based operations with automatic rollback on errors
• ✔ Complete audit trail of all synchronization activities
• ✔ Windows Service or Console app deployment options

Technical Stack

• ASP.NET Core 8.0 MVC
• Entity Framework Core
• SQL Server
• ASP.NET Identity
• Serilog