PHP tool/script that compares multiple MySQL DBs and prints script to synchronize it?

This page summarizes the projects mentioned and recommended in the original post on /r/PHPhelp

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • DBDiff

    Compare MySQL databases & automatically create schema & data change scripts/migrations rapidly (up & down SQL supported) for database version control. Supports *some* migration tools.

  • I need a tool in PHP that compares all databases against a "main database" and if the main DB contains changes, it should print a script that synchronizes all of them. I found this: https://github.com/DBDiff/DBDiff but the problem is that I couldn't even test it as I can't run this command in cmd in windows: ./build which according to the description should create a folder with some files in it. The author did not give much explanation in it.

  • php-mysql-diff

    MySQL Schema Diff - Comparison / Migration Script Generation

  • This will not work because it DROPS tables when ALTERING them: https://github.com/camcima/php-mysql-diff

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • compalex

    Lightweight script to compare two database

  • This one I have not tested yet if it works or not: https://github.com/dlevsha/compalex/

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts