mtcmedia/db-diff

Database diff tool for comparing schemas

Maintainers

Details

github.com/mtcmedia/db-diff

Homepage

Source

Issues

Installs: 13

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 4

Forks: 0

Open Issues: 0

v1.0.0 2021-01-19 16:52 UTC

Requires

MIT 07f3c48c098332d0432821f395a327f787b5f057

db diffmysql diff

This package is auto-updated.

Last update: 2024-04-20 00:56:38 UTC

README

This tool is a database schema comparison tool within Laravel. It is meant to be used to compare schemas for tables or table columns between two similar databases.

Tool is primarily tested on MySql however should work on other schemas as well.

Installation & Usage

Install package using composer

composer require mtcmedia/db-diff

Laravel auto-registers module and its commands so no other installation steps required.

Package offers following commands

php artisan db-diff:list-tables 

php artisan db-diff:list-columns

The list tables command will compare table names only and list any missing tables on your local (default) database.

The list columns command will compare all columns in tables and list missing columns (or full tables with all columns) in both directions

Database selection uses config/database.php to list connections that can be used for comparison.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security-related issues, please email opensource@mtcmedia.co.uk instead of using the issue tracker.

License

The package is provided under MIT License. Please see License File for more information.