Repository files navigation

Compalex is a lightweight script to compare two database schemas. It supports MySQL, MS SQL Server and PostgreSQL.

Trydemo or visithttp://compalex.net/

The easiest way to use Compalex is to use Docker.

You can build your own container using Dockerfile or use Docker Hub image:

docker run -it -e DATABASE_DRIVER='mysql' \-e DATABASE_ENCODING='utf8' \-e SAMPLE_DATA_LENGTH='100' \-e DATABASE_HOST='host.docker.internal' \-e DATABASE_PORT='3306' \-e DATABASE_NAME='compalex_dev' \-e DATABASE_USER='root' \-e DATABASE_PASSWORD='password' \-e DATABASE_DESCRIPTION='Developer database' \-e DATABASE_HOST_SECONDARY='host.docker.internal' \-e DATABASE_PORT_SECONDARY='3306' \-e DATABASE_NAME_SECONDARY='compalex_prod' \-e DATABASE_USER_SECONDARY='root' \-e DATABASE_PASSWORD_SECONDARY='password' \-e DATABASE_DESCRIPTION_SECONDARY='Production database' \-p 8000:8000 dlevsha/compalex

You need to change variables for your own

DATABASE_DRIVER - database driver, possible value

• mysql - for MySQL database
• pgsql - for PostgreSQL database
• dblib - for Microsoft SQL Server database
• oci - for Oracle database

DATABASE_HOST andDATABASE_HOST_SECONDARY - database host name or IP for first and second server

If your compared DB run locally:

• forMacOS andWindowsuser: usehost.docker.internal instead oflocalhost inDATABASE_HOST andDATABASE_HOST_SECONDARY param.Because we run script inside container we need to use Host machine IP for connection.

• forLinux user: use--network host option andlocalhost inDATABASE_HOST andDATABASE_HOST_SECONDARY param.

If you connect to DB outside your machine (external IP) use:-e DATABASE_HOST='[Your external IP]'.

DATABASE_PORT andDATABASE_PORT_SECONDARY - database port for first and second server

Default ports for DB:

• 3306 - Mysql
• 5432 - PostgreSQL
• 1433 - MSSQL
• 1521 - Oracle

DATABASE_NAME andDATABASE_NAME_SECONDARY - first and second database name

DATABASE_USER /DATABASE_PASSWORD andDATABASE_USER_SECONDARY /DATABASE_PASSWORD_SECONDARY - login and password to access your databases

DATABASE_DESCRIPTION andDATABASE_DESCRIPTION_SECONDARY - server description (not necessary). For information only. These names will display as a database name.

You can also usedocker-compose.yml.

version: "3.7"services:  compalex:    image: dlevsha/compalex    container_name: compalex    environment:      - DATABASE_DRIVER=mysql      - DATABASE_ENCODING=utf8      - SAMPLE_DATA_LENGTH=100      - DATABASE_HOST=host.docker.internal      - DATABASE_PORT=3306      - DATABASE_NAME=compalex_dev      - DATABASE_USER=root      - DATABASE_PASSWORD=password      - DATABASE_DESCRIPTION=Developer database      - DATABASE_HOST_SECONDARY=host.docker.internal      - DATABASE_PORT_SECONDARY=3306      - DATABASE_NAME_SECONDARY=compalex_prod      - DATABASE_USER_SECONDARY=root      - DATABASE_PASSWORD_SECONDARY=password      - DATABASE_DESCRIPTION_SECONDARY=Production database    ports:      - "8000:8000"

If you prefer use Compalex as PHP script please read instruction bellow.

Compalex is only supported by PHP 5.4 and up with PDO extension.

$ git clone https://github.com/dlevsha/compalex.git$ cd compalex

Open.environment. You'll see configuration params

[ Main settings ]; Possible DATABASE_DRIVER: 'mysql', 'pgsql', 'dblib', 'oci'.; Please use 'dblib' for Microsoft SQL ServerDATABASE_DRIVER = mysqlDATABASE_ENCODING = utf8SAMPLE_DATA_LENGTH = 100[ Primary connection params ]DATABASE_HOST = localhostDATABASE_PORT = 3306DATABASE_NAME = compalex_devDATABASE_USER = rootDATABASE_PASSWORD =DATABASE_DESCRIPTION = Developer database[ Secondary connection params ]DATABASE_HOST_SECONDARY = localhostDATABASE_PORT_SECONDARY = 3306DATABASE_NAME_SECONDARY = compalex_prodDATABASE_USER_SECONDARY = rootDATABASE_PASSWORD_SECONDARY =DATABASE_DESCRIPTION_SECONDARY = Production database

where

DATABASE_DRIVER - database driver, possible value

• mysql - for MySQL database
• pgsql - for PostgreSQL database
• dblib - for Microsoft SQL Server database
• oci - for Oracle database

[ Primary connection params ] and[ Secondary connection params ]sections describes settings for first and second databases.

Where

DATABASE_HOST andDATABASE_HOST_SECONDARY - database host name or IP for first and second server

DATABASE_PORT andDATABASE_PORT_SECONDARY - database port for first and second server

Default ports:

• 3306 - Mysql
• 5432 - PostgreSQL
• 1433 - MSSQL
• 1521 - Oracle

DATABASE_NAME andDATABASE_NAME_SECONDARY - first and second database name

DATABASE_USER /DATABASE_PASSWORD andDATABASE_USER_SECONDARY /DATABASE_PASSWORD_SECONDARY - login and password to access your databases

DATABASE_DESCRIPTION andDATABASE_DESCRIPTION_SECONDARY - server description (not necessary). For information only. These names will display as a database name.

Insidecompalex directory run

$ php -S localhost:8000

Now open your browser and typehttp://localhost:8000/

You'll see database schema of two compared databases.

You can run this script in terminal (for example, if you don't have direct connection to database).

I recommendeLinks (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.

Then run:

$ elinks http://localhost:8000

You'll see database schema in your terminal

Sometimes you have only SSH access to remote database server and you can't open port for external connections.In this case you can use port forwarding via SSH

ssh -L 1522:localhost:1521 [user name]@[remote host 1]ssh -L 1523:localhost:1521 [user name]@[remote host 2]

This command will forward1521 port from remote servers to local1522 and1523 respectively.

Copyright (c) 2021, Levsha Dmitry

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS ORIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THEAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHERLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS INTHE SOFTWARE.