FAQ
Common questions, answered. A support contact is on its way and will be published here.
Running into an error or unexpected behavior? See the troubleshooting guide.
Which platforms are supported?
macOS and Windows. Linux support is in the works — stay tuned.
Can I try it for free?
Yes. SQLite connections only: no feature limits, no trial period. No account, no credit card.
Does it replace Flyway / Liquibase?
Either way works — side by side or DiffyPick on its own. But when you split the roles — your migration tool for history, DiffyPick for what the database actually looks like right now — your existing migration files stay healthier.
Is it safe to point at production?
A preflight check runs on the confirmation screen before execution. In most cases there is nothing to worry about — and when there is a risk or warning, it is shown clearly. A backup is one click away right before executing, so if you are unsure, take one first.
Is there a 1-year plan?
No. Keeping up with five evolving databases takes a development budget we can plan on long-term, and a 1-year prepay wouldn’t let us offer a meaningful discount over monthly. The 2-year plan is where we can — 17% off. If you expect to use DiffyPick for about a year, the monthly plan is a good fit: 12 months comes to $216, still less than the 2-year plan, and you can cancel anytime.
Can I compare across different DBMS?
Yes. Any combination of MySQL, MariaDB, PostgreSQL, SQL Server and SQLite can be compared, and table and column structures convert and sync across dialects. Engine-specific objects are out of scope for migration.
Where are my connection credentials stored?
Everything stays on your machine, with secrets encrypted using AES-256-GCM. Exported connection files are also encrypted with a password of your choice.
Is my schema or data ever sent anywhere?
No. Comparison and sync happen entirely between your machine and your databases. The only outbound connections are license verification and update checks.
Can it reach databases behind a bastion (SSH)?
Yes. Multi-hop SSH tunnels are supported, and SSL/TLS client certificates can be configured per connection.
Do backups and restores need extra software?
Backups and restores for MySQL / MariaDB / PostgreSQL / SQL Server use each database’s official CLI (mysqldump, pg_dump, and so on). If a CLI is not on your PATH, you can set its location manually in Settings. SQLite needs nothing extra.
What happens if a sync fails?
SQL runs one statement at a time; on failure it stops on the spot and shows you the result. If you took a backup beforehand, you can restore it from history right away.
How do updates arrive?
DiffyPick checks for a new version at startup and notifies you. You choose when to download and apply — it never updates itself behind your back.