Download SchemaSync Professional

Faster comparison on large schemas, clearer handling of generated columns, and a fix for index ordering in generated scripts.

• ImprovedSchema metadata is now read in a single pass per object type, cutting comparison time on schemas above 2,000 objects by roughly a third.
• AddedGenerated columns are compared as first-class objects, including VIRTUAL and STORED differences and expression changes.
• AddedComparison filters can be saved per connection pair, so per-environment exceptions no longer have to be re-entered.
• FixedComposite indexes could be emitted before the columns they reference when several tables changed in the same migration.
• FixedRestoring a snapshot taken from MariaDB no longer reports a false difference on utf8mb3 columns.

Schema snapshots, selective synchronization, and a redesigned difference viewer.

• AddedSchema snapshots — save the structure of any connection to a file and compare a live database against it, or compare two snapshots.
• AddedSelective synchronization: choose individual differences and generate a script containing only those, with dependency order preserved.
• ImprovedThe difference viewer now aligns both definitions line by line and ignores whitespace, comment and ordering noise.
• ImprovedConnections can be marked read-only, which refuses write statements at the application level regardless of database privileges.

Backup retention policies and offline activation.

• AddedRetention policies for backups, by count or by age, applied per connection.
• AddedOffline activation for machines without internet access, using a request code and a licence file.
• ImprovedPre-flight checks now verify privileges for every statement in the plan before the first one runs.
• FixedTrigger definitions containing a DELIMITER change could be truncated on export.