dbcmp

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

1. dbcmp comes with a user-friendly command line interface that requires minimal configuration.
2. Currently, dbcmp supports MySQL and PostgreSQL. You can also compare content between same database systems.
3. 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)
4. The tool provides minimal output, allowing you to easily focus on which tables are different.
5. dbcmp is not designed to handle large datasets hence we recommend this tool for relatively smaller databases. Optimizations may come in future versions.

How to Use dbcmp

1. To install dbcmp, simply run:

   go install github.com/isacikgoz/dbcmp/cmd/dbcmp

2. To Configure, dbcmp requires access credentials for the databases you want to compare. You can set them directly as command line arguments.

3. To perform a basic comparison between two databases, use the following command:

   dbcmp --source source_dsn --target target_dsn

4. If you wish to exclude specific tables, you can use the --exclude option:

   dbcmp --source source_dsn --target target_dsn --exclude=table1,table2

Now you have the power to compare database content effortlessly with dbcmp. Happy comparing!