dlevsha / compalex Goto Github PK
View Code? Open in Web Editor NEWLightweight script to compare two database
Lightweight script to compare two database
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
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.
Don't support other ports.
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.
For those of us not using PHP, this seems like the ideal app to deploy in a Docker - anyone able to do this?
Please could you add support for Oracle ?
It would be great.
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?
Great Work!
It is possible to generate the update script automatically?
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 ?
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.