apgdiff vs dbForge Studio for MySQL
apgdiff
github.comdbForge Studio for MySQL
devart.comSide by side
| Figure | apgdiff | dbForge Studio for MySQL |
|---|---|---|
| Price from | Free | $8.33/mo |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Plans published | 1 | 10 |
| Spec score · Database Schema Comparison Tools | 8.2 (#6) | 8.2 (#7) |
| Founded | 2006 | 1997 |
| Supported systems | The homepage lists Windows, Linux, Mac OS X, Solaris, and BSD, and says it can run on other systems where Java is available. | MySQL, MariaDB, Percona, HeatWave, Galera and cloud services |
Plans
dbForge Studio for MySQL
- ExpressPriced on request
- Standard$9.95 a month
- ProfessionalPriced on request
- EnterprisePriced on request
- ExpressFree
- Professional$19.95 a month
- Enterprise$24.95 a month
- Standard$99.95 a year
- Professional$179.95 a year
- Enterprise$229.95 a year
In their own words
apgdiff
apgdiff is a free command-line tool that compares two PostgreSQL schema dump files and generates DDL statements to update an older schema or show differences. It takes an original dump and a new dump as inputs; generated SQL can be printed in the terminal or redirected to a file. The project says it can be called from batch jobs or web applications. It is written in Java and requires Java 1.6 or newer. Listed systems include Windows, Linux, Mac OS X, Solaris, and BSD, as well as other systems where Java is available. Version 2.4 is identified as the latest stable release, with binary and source ZIP downloads. Support covers selected ALTER SEQUENCE, ALTER TABLE, ALTER VIEW, COMMENT, CREATE FUNCTION, CREATE INDEX, CREATE SCHEMA, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE VIEW, and SET search_path statements. Other SQL statements are ignored, and an option reports ignored DDL. For CREATE TABLE column constraints, only NULL and NOT NULL are supported. The project uses the MIT License and recommends reviewing generated upgrade SQL before applying it.
dbForge Studio for MySQL
dbForge Studio for MySQL is a desktop database tool for MySQL, MariaDB, Percona, and HeatWave. It runs on Windows, macOS, and Linux and provides data editing, visual data and object editors, a database designer, visual query building, SSH tunneling, and query history. Query results can be exported to HTML, Text, XLS, XLSX, Google Spreadsheet, MS Access, RTF, PDF, JSON, XML, CSV, ODBC, DBF, and SQL. The Express plan lists formatting, visual editors, design, import and export, and security and session managers. Standard adds debugging, query profiling, backup and recovery, database search, and SQL refactoring for $9.95 a month, billed monthly. Professional lists schema and data comparison and synchronization, command-line automation, database projects, pivot tables, and reports. Enterprise lists source control, data generation, documentation, database copying, invalid-object finding, and script-folder comparisons. A free plan is available, while paid access starts at $9.95 per user per month. Devart was founded in 1997.