dbdiff
dbdiff copied to clipboard
gimenete
Compares two postgresql or mysql databases and prints SQL commands to modify the first one in order to match the second one
Is there an easy way to modify this script to diff two sql files containing a schema definition? I'm not too much of a database guy generally, but if you...
Instead of install dbdiff with -g (which requires sudo privileges for many of us), how about this? - mkdir somedir - cd somedir - npm init -y - npm install...
When running dbdiff on a postgres database I get the following message and nothing else happens: (node:9660) DeprecationWarning: PG.connect is deprecated - please see the upgrade guide at https://node-postgres.com/guides/upgrading I...
When a table has attribute default value the final create table statement does not include a single quote around the default value, as a result when the query is run...
When a table has attribute default value the final create table statement does not include a single quote around the default value, as a result when the query is run...
/usr/local/lib/node_modules/dbdiff/dbdiff.js:6 class DbDiff { ^^^^^ SyntaxError: Block-scoped declarations (let, const, function, class) not yet supported outside strict mode at exports.runInThisContext (vm.js:53:16) at Module._compile (module.js:374:25) at Object.Module._extensions..js (module.js:417:10) at Module.load (module.js:344:32)...
If table1 has constraints that table2 does not, they would not be dropped. Introducing lodash allows to user differenceWith, which makes clear and simple the comparison and get rid of...
Hello ! Is it possible to use the diff yml to update the old database to be the same ? I was thinking to a case when I have the...
I ran all of the regression tests in test/test-mysql.
