Database compare (Premium)

Database compare tool allows comparing structure of two databases. Whhich objects are compared:

tables, columns, primary/foreign keys
views
stored procedures
functions

Although the most used scenario is to compare two databases with the same engine, you could also compare databases with differnet engines, compare single-schema database agains one schema in multi schema-database or compare database model stored in YAML files against real database.

You could also deploy changes from source ta target database.

Database compare options

Ignore case or schemae name
Disable drop tables/columns/views. When the object is missing, you could ignore this (the safest variant) or mark object as deleted (eg. rename deleted column “Fax” to “_deleted_Fax”)
Ignore foreign key actions
Ignore data types

Database compare tool

DB compare settings