SchemaSync Professional 1.4: snapshots, selective sync, and a faster engine
Compare a live database against a saved state, apply only the differences you are ready for, and get results on large schemas roughly a third faster.
SchemaSync Product
Product team · NG&NR Technologies
Version 1.4 is available now. It is built around a request we heard repeatedly: comparison should not require two live databases, and deployment should not be all or nothing.
Schema snapshots
You can now save the complete structure of any schema to a file and use it anywhere a connection would go. That makes several previously awkward jobs simple: keep a known-good baseline from just after a release, compare two points in time without touching either database, or review a schema you have no network access to.
Snapshots hold structure only — no table data and no credentials — so they are safe to commit to a repository. Doing so gives your schema a reviewable history alongside the code that depends on it.
Selective synchronization
Every difference now has a checkbox, and the generated script contains only what you selected — with dependency ordering recalculated for that subset. Shipping one change while holding another back no longer means hand-editing SQL.
Synchronize orders_dev → orders_prod
Step 3 of 4 · applying changes
Pre-flight checks
Privileges, engine and charset verified
Backup target schema
orders_prod-20260714-2104.sql · 42 MB
ALTER TABLE `orders`
MODIFY COLUMN `status` — running
CREATE INDEX `idx_orders_placed_at`
Queued
Verify and re-compare
Confirms the target matches the source
A faster comparison engine
Schema metadata is now read in one pass per object type instead of per object. On schemas above roughly two thousand objects this cuts comparison time by about a third, and the improvement is largest exactly where it matters most — over a high-latency connection, where every round trip is paid for.
A rebuilt difference viewer
Both definitions are now aligned line by line, with changed lines marked and whitespace, comment and ordering noise filtered out. Status is shown by glyph and label as well as by colour, so the meaning survives for anyone who cannot easily distinguish red from green.
Read-only connections
A connection can be marked read-only, and SchemaSync will then refuse write statements at the application level whatever the database privileges permit. It takes one checkbox and removes an entire category of accident. We suggest setting it on every production connection you do not deploy from.