Skip to main content
Backup and restore

Backup

Take schema and data snapshots on demand or on a schedule, with retention limits.

Backups are written to a folder you choose, on your machine or on a network share you have access to. Nothing is uploaded anywhere.

Backup

Schema and data snapshots

Back up nowScheduleRetention
Backing up orders_prod · 27 of 42 tables64%

Streaming to disk · 6.4 MB/s · about 12 seconds remaining

Recent backupsSize

orders_prod-20260714-2104.sql

Today, 21:04 · Pre-sync

42.1 MB

orders_prod-20260713-0200.sql

Yesterday, 02:00 · Scheduled

41.8 MB

orders_stage-20260712-1740.sql

12-Jul-26, 17:40 · Manual

38.4 MB
Stored locally · D:\SchemaSync\backups
A backup in progress, with recent snapshots and their retention tags.

Choosing what to include

Schema only
Structure without rows. Small and fast, and enough to restore or compare a schema. The right default for pre-deployment snapshots.
Schema and data
Structure plus table contents. Necessary before any change that could lose data, such as narrowing a column type or dropping one.

Retention

Set a policy per connection — keep the last *n* backups, or keep anything newer than *n* days — and SchemaSync removes older files as new ones are written. Backups taken automatically before a synchronization are tagged so they can be retained separately from scheduled ones.