Is Unicode aware, can work with UTF8 data, which includes foreign characters/symbols.Works with existing migration tools like Flyway and Simple DB Migrate by specifying output template files/formats, for example, Simple DB Migrate may work with simple-db-migrate.tmpl which includes: SQL_UP = u''' ''' SQL_DOWN = u''' '''.Since this diff tool is being used for migrations, it provides up and down SQL in the same file.Diffs are SUPER fast and this tool has been tested with databases of multiple tables of millions of rows.Some tables and/or fields can be ignored in the comparison with a YAML collection in the config file (see File Examples).Diffs can include changes to the schema and/or data, both in valid SQL to bring the target up-to-date with the source.Connects to a source and target database to do the comparison diff, locally and remotely.Works on Windows, Linux & Mac command-line/Terminal because it has been developed in PHP.If you are an individual, company or organisation interested in commercial support packages for DBDiff then please get in touch.For getting a mention in return, please consider: When used alongside a compatible database migration tool, it can help enable database version control within your team or enterprise.ĭBDiff is a MIT-licensed open source project with its ongoing development made possible entirely by the support of backers. It compares two databases, local or remote, and produces a migration file of the differences automatically.

DBDiff is an automated database schema and data diff tool.

Mac difftool