Introducing dbcmp - Your Command Line Database Content Comparison Tool
Description
dbcmp is a powerful and efficient command line tool designed to simplify the process of comparing content between two databases. dbcmp empowers you to quickly identify discrepancies and inconsistencies in data, facilitating data integrity and accuracy.
Key Features
dbcmp comes with a user-friendly command line interface that requires minimal configuration.
Currently, dbcmp supports MySQL and PostgreSQL. You can also compare content between same database systems.
You can specify the tables (and maybe columns) you want to compare, giving you granular control over the comparison process and avoiding unnecessary comparisons. (TBA)
The tool provides minimal output, allowing you to easily focus on which tables are different.
Support for large databases; native pagination provides a comparison process that doesn't bring much load on your databases.
How to Use dbcmp
To install dbcmp, simply run:
go install github.com/mattermost/dbcmp/cmd/dbcmp
To Configure, dbcmp requires access credentials for the databases you want to compare. You can set them directly as command line arguments.
To perform a basic comparison between two databases, use the following command:
dbcmp --source source_dsn --target target_dsn
If you wish to exclude specific tables, you can use the --exclude option: