Features
Everything you need to keep databases in step
From a single comparison to a release moving through every environment.
Schema compare
Compare two databases, or one schema in each, and see every object that is new, missing or different.
- Both definitions side by side, or the change script for one object
- Filter by name and object type, move through the list with the keyboard
- Compare a project against all its extra targets at once
Deploy
Choose the differences to deploy, review the script and its risks, and run it.
- Warnings for statements that alter or recreate existing objects
- Checks that the databases have not changed since the comparison; on MySQL, that the target's rows will not make the script fail
- One transaction on PostgreSQL and SQL Server; a rehearsal on a scratch copy for MySQL
- Your own SQL before and after, and a fresh comparison when it is done
Data compare and sync
Compare the rows of matching tables and run a script that makes the target match.
- Compare with a target table of another name, and map columns of other names or leave them out
- Choose the key that pairs rows, checked for duplicates and blanks first
- Filter the rows with a WHERE condition, tested before it is saved
- Foreign keys switched off during the sync and checked again before it commits
Pipelines
Compare a chain of databases, like dev, staging and production, in one go.
- Run every hop at once and see which have differences
- Deploy a hop from the pipeline; the next hop is compared again
- Every run kept in the pipeline history
ERDs
Draw an entity-relationship diagram of a database, arrange it, and share it.
- Find a table or column in the diagram
- Export as an image, or to Lucidchart
Renames
Declare a renamed table, view, sequence, function or column, and the deployment renames it, its rows kept.
Snapshots
Save a copy of a database's schema, to look back at how it was.
History
Every comparison and deployment is kept, with the SQL each deployment ran.
Private by design
Runs on your machine. Saved passwords are encrypted for your Windows account.
All of it, free.
