Data Sync Dashboard

Data Explorer

Use the Data Explorer to securely search for specific records in the source database tables. This is a read-only tool for quick lookups and diagnostics.

Open Data Explorer

Application Controls

Reload Scheduler

This is a "soft" reload. Use this if you have manually edited a job's schedule in the job_config table and want the change to take effect without a full application restart. It only reloads the scheduler's job definitions from the database.

Seed Database with Fake Data

DANGER ZONE

This action is EXTREMELY DESTRUCTIVE and irreversible. It will permanently DELETE ALL BUSINESS DATA from the following tables and replace it with new, randomly generated fake data:

dbo.membership
dbo.service
dbo.invoiceHed & dbo.invoiceItem
dbo.ServiceInvoice
dbo.receipt

This is only for setting up a clean test environment. NEVER run this on a production database.

Reset Application Data (Hard Reset)

WARNING ZONE

This is a **full application reset** and is irreversible. It will permanently delete all data from the application-specific tables:

All Sync Logs (dbo.sync_log) will be erased.
All Job Configurations (dbo.job_config) will be reset to their defaults.
All saved Data Mappings (dbo.mapping) will be deleted and re-seeded with defaults.

After resetting the data, the scheduler will also be reloaded. This is the primary button to use when you want a completely fresh start without affecting source business data.