What is Compalex?
Compalex is a lightweight script to compare two database schemas. It supports MySQL, MS SQL Server and PostgreSQL.
View project on https://github.com/dlevsha/compalex/
Compalex is only supported by PHP 5.4 and up with PDO extension.
$ git clone https://github.com/dlevsha/compalex.git $ cd compalex
or you can download latest version here.
.environment. You'll see configuration params
[ Main settings ] ; Possible DATABASE_DRIVER: 'mysql', 'pgsql', 'dblib'. ; Please use 'dblib' for Microsoft SQL Server DATABASE_DRIVER = mysql DATABASE_ENCODING = utf8 SAMPLE_DATA_LENGTH = 100 [ Primary connection params ] DATABASE_HOST = localhost DATABASE_NAME = compalex_dev DATABASE_USER = root DATABASE_PASSWORD = DATABASE_DESCRIPTION = Developer database [ Secondary connection params ] DATABASE_HOST_SECONDARY = localhost DATABASE_NAME_SECONDARY = compalex_prod DATABASE_USER_SECONDARY = root DATABASE_PASSWORD_SECONDARY = DATABASE_DESCRIPTION_SECONDARY = Production database
DATABASE_DRIVER - database driver, possible value
mysql- for MySQL database
pgsql- for PostgreSQL database
dblib- for Microsoft SQL Server database
[ Primary connection params ] and
[ Secondary connection params ]sections describes settings for first and second databases.
DATABASE_HOST_SECONDARY - database host name or IP for first and second server
DATABASE_NAME_SECONDARY - first and second database name
DATABASE_PASSWORD_SECONDARY - login and password to access your databases
DATABASE_DESCRIPTION_SECONDARY - server description (not necessary). For information only. These names will display as a database name.
compalex directory run
$ php -S localhost:8000
Now open your browser and type
You'll see database schema of two compared databases.
Run in terminal
You can run this script in terminal (for example, if you don't have direct connection to database).
I recommend eLinks (free text-based console web browser) because it supports HTML-formatting and colors.
Install the script and run web-server as described above on your server.
$ elinks http://localhost:8000
You'll see database schema in your terminal