40,000 lines re-sorted.
3 rows changed.
What changed in this table, this schema, this migration? Diffacto matches rows by key and tables, columns and indexes by name, so a re-sorted file shows only the rows that changed, a renamed column shows as a rename, and a migration says what it does before anything runs.
For Macs with Apple silicon. Every download includes 14 days of every feature, with no account and no card. Windows 10 and 11 (beta) and Linux are in testing; see Download.
Tables and data files, matched by key
Each kind of file gets its own reader and its own view. When Diffacto can't read something by meaning, it falls back to structure, then lines, then bytes, and says which it used.
-
Tables
ChangedRows: 3 changed, 1 added, 1 removed; column
emailrenamed tocontact_emailCSV, TSV, Excel, OpenDocument spreadsheets, Numbers, Parquet, Arrow and Avro. Name the key column (
--key id) or let Diffacto guess one; it says when it guessed, and when a key repeats. Moved rows are moves, not changes; added, removed, renamed and retyped columns are listed; numbers within a tolerance you set count as equal. Past 2,000,000 rows on a side, Diffacto compares a sample of the keys, the same on both sides, and says so;--sample-rows 0compares every row. -
Column statistics
Changed
amount: mean 41.2 → 47.9; nulls 0.1% → 3.4%Each column's mean, share of nulls and distinct values are compared, with a score for how far its distribution shifted (PSI).
-
Spreadsheets
ChangedD14: =SUM(D2:D13) → =SUM(D2:D12) (1,204 → 1,150)
Excel (.xlsx, .xlsm, .xlsb, .xls), OpenDocument and Numbers files. Formulas are compared as formulas and as values; sheets added, renamed, moved or hidden are listed, and so are comments.
-
Structured data
Changedlodash 4.17.20 → 4.17.21; 3 transitive packages added
JSON, YAML, TOML, XML, property lists, lockfiles, MessagePack, BSON and Protobuf, matched by key path instead of by line.
--id-fieldnames the field that identifies array items. Three-way merge covers structured data and SQL schemas.
Databases: schemas, rows and migration scripts
Diffacto only reads. It refuses any statement that writes, and it connects only when you say so. SQL Server and Snowflake have no read-only session, so for those a login or role that can only read is the safer choice.
-
Schemas
Changed
users.emailtype changed from VARCHAR(120) to VARCHAR(255);order_itemsrenamed toline_itemsPostgreSQL, MySQL, MariaDB, SQL Server, Snowflake and BigQuery, live, or as a SQL file or a SQLite database on either side. Diffacto reads the catalogs: tables, columns, keys, indexes, views, routines, grants and comments. Passwords can stay in your keychain, and a connection can go through SSH. Between two engines, types are compared by what they mean, and what only one engine has is noted. Snowflake and BigQuery are part of the Data pack.
-
Rows
Changed
orders: 12 rows changed, 3 added, 1 removedLive tables compare row by row by primary key, including between different database engines (Data pack). Diffacto reads checksums of key ranges first and then only the rows in ranges that differ, so large tables aren't copied.
-
Migrations
AddedA script of 6 statements, with comments on what may lose data
diffacto migratewrites the script that turns one schema into the other, for PostgreSQL, MySQL and MariaDB, SQL Server and SQLite. It is written and never run: read it, and run it on a copy first. It follows the same pairing as the comparison, so the script and the diff agree on what was renamed, and--renamelets you name a rename yourself. Scripts for Snowflake and BigQuery, and between two different engines, aren't written yet.
Works where you already compare
- The terminal. The
diffactocommand prints the same changes as text, JSON or HTML, with exit codes for scripts.diffacto migrateexits 0 when the schemas are the same, 1 when they differ and 2 on an error. - Git.
diffacto git install --driversmakes plaingit diffandgit log -pshow SQLite databases, spreadsheets, Parquet, Arrow and Avro files, and lockfiles as text, with no app needed. - Snapshots.
diffacto snapshotkeeps a database as it is now in a file, with its rows' checksums if you ask, so you can compare it later with no server at all. A snapshot holds no password, and compares with a database of any engine.
$ diffacto diff orders-old.csv orders-new.csv --key id $ diffacto migrate db:staging db:prod -o staging-to-prod.sql $ diffacto snapshot db:prod -o prod-monday.dsnap --rows $ diffacto diff prod-monday.dsnap db:prod --rows
Try it on your own files
Every download starts with 14 days of every plan and pack, with no account and no card. After that, Free stays free, and you can buy a plan from the app. Plans, packs and prices are in the pricing section.
Diffacto sends no analytics or crash reports, and never sends us file contents, names or paths.
For other teams
- Game teams. Textures, 3D scenes, Perforce and Unity Version Control.
- Documents. Word, PDF, Pages, slides, spreadsheets and notebooks.
- Media. Images, audio and video, with delivery checks.
- Everything else. Code, design files and more, on the home page.