dlevsha / compalex Goto Github PK

Is there a future release where there is a 1 click list of mysql commands to update db1 structure to match db2 structure or vice versa? This is a great application btw.

When a table does not exist on either primary or secondary, the page displays the following php warning under the table name when using php versions greater than 7.1.

Warning: count(): Parameter must be an array or an object that implements Countable in home/vagrant/Compalex/compalex/template/compare.php on line 72

This warning is also displayed on the CLI screen.

Sorry I have not had enough time to suggest a fix yet.

Please could you add support for Oracle ?
It would be great.

Don't support other ports.

I think you need to use the already defined methods for color displaying changes:
absence - empty red line
appearance - green text
change - old in red and new in green

example: https://lh3.googleusercontent.com/proxy/v2OKdeAj5p7RGjMA-jZy6OfKgFElXNdiGlbquhlV8-rJYleaMX_eXhOvfEq7SKlMD1xsTu5kEsfLc4uIc18-20pxwodYADfuIZruQQ

For those of us not using PHP, this seems like the ideal app to deploy in a Docker - anyone able to do this?

Hello i try to compare two Azure MS SQL Databases but i always get:

Compalex
Database schema compare tool
ERROR:
SQLSTATE[01002] Adaptive Server connection failed (COOLHOSTNAME:1433) (severity 9)
Stack trace:
#0 /usr/src/compalex/driver/abstract.php(34): PDO->__construct('dblib:host=COOL...', 'ACOOLUSERNAME...', 'CRYPTICPASSWORD...', Array)
#1 /usr/src/compalex/driver/abstract.php(17): BaseDriver->_getConnect('dblib:host=COOLHost...', 'cooldatabasename...')
#2 /usr/src/compalex/driver/abstract.php(65): BaseDriver->_getSecondConnect()
#3 /usr/src/compalex/driver/mssql.php(22): BaseDriver->_getCompareArray('SELECT DISTINCT...')
#4 /usr/src/compalex/index.php(28): Driver->getCompareTables()
#5 {main}

I added a dns server to the docker-compose so i am sure he can resolve the hostname, also i am sure about the used usernames/passwords/databasenames.

What could i do wrong ?

Sorry, could not easily find where to submit a request for new feature.
We are designing an internal tool that does something similar, but would be happy to use this.
We have several databases on our server, and some of them have a delta database. This is a database that tracks changes in each field (basically, copies the field before the change+ adds four meta fields unique id, delta date, delta type, delta comment). The point is, I need to compare the delta db to its real life counterpart and make sure they are 100% same. With the exceptions of the added 4 fields.

That was a real life example to what we need a schema checker like that + the ability to add exceptions.
Is it in the road map?

I setup Apache2.4.26(Win64) and PHP Version 7.0.21 added php_pdo_sqlsrv_7_ts_x64.dll and php_sqlsrv_7_ts_x64.dll. As result i got this error. Please give me the tip to solve this problem. Thank you.

Mariadb/mysql table field default and Null column comparison isn't implemented or not working.

All 'Sample data' links in both columns get data from the first database instead of each of its.

If the user's password contains a question mark "?" then Compalex fails with error "compare’s server IP address could not be found". This is because the generated URL can not be parsed with PHPs parse_url and returns false instead, causing the connection to fail.

I could only get around this by creating a new sql account without this character in the randomly generated password

Great Work!

It is possible to generate the update script automatically?