How to compare two tables - Geeksltd/DbDarwin GitHub Wiki

Version 1.0.0

Added two buttons to compare data and compare schema

What objects checked for comparison?

  1. new or removed tables
  2. new or removed columns
  3. change type, default value of columns
  4. new or remove or change index or primary key

app db darwin

How to detect table for compare :

  1. The database administrator or developer should add extend property on the table click right on a table - click properties and then click extended properties than double click on row type "ReferenceData" for name and value is "Enum" like this image

  2. table should contain name column and is not be null

Extended Property