Our great sponsors
-
DBDiff
Compare MySQL databases & automatically create schema & data change scripts/migrations rapidly (up & down SQL supported) for database version control. Supports *some* migration tools.
-
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.
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.
This will not work because it DROPS tables when ALTERING them: https://github.com/camcima/php-mysql-diff
This one I have not tested yet if it works or not: https://github.com/dlevsha/compalex/
Related posts
- The easiest way to compare two database schemas (MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle).
- GitHub - jim-schwoebel/dopg_cli: A python command line interface for DigitalOcean postgres clusters (5+ integrations).
- SchemaHero Is a Kubernetes Operator for Declarative Schema Management
- Working with jOOQ and Flyway using Testcontainers
- Maybe a dumb question ... but is there a default schema migration tool? for postgresql?