Datatabase diff #29

New issue

Open

opened 2018-11-20 17:27:07 +00:00 by eelke · 0 comments

eelke commented

2018-11-20 17:27:07 +00:00

(Migrated from gitlab.com)

Ability to compare two databases

Compare schema

schema's
tables
views
functions
sequences

tables

columns: names type default null by default ignore order
indexes,
constraints
- primary key
- foreign keys
- check
triggers
other attributes like fill factors

Compare data

Compare tables rows based on primary key. Allow different columns. Allow user select which columns to compare. Missing columns will be compared as if they are filled with NULL or maybe default?

Ability to compare two databases # Compare schema - schema's - tables - views - functions - sequences ## tables - columns: names type default null by default ignore order - indexes, - constraints - primary key - foreign keys - check - triggers - other attributes like fill factors # Compare data Compare tables rows based on primary key. Allow different columns. Allow user select which columns to compare. Missing columns will be compared as if they are filled with NULL or maybe default?