Problem
Compare & Sync compares structure. Two databases with the same schema and different rows compare as identical, so there is no way to see which rows differ or to generate the statements that would bring one in line with the other.
Proposed solution
- A data comparison mode beside the structure one, per table, keyed on the primary key or a chosen key.
- Rows shown as added, removed or changed, with the differing columns highlighted.
- Generate the INSERT, UPDATE and DELETE script, reviewable before anything runs, exactly as the structure script is today.
- A row limit and a WHERE filter per table, since comparing two large tables in full is not always what is wanted.
- Refuse to run against a target whose safe mode level is read-only, as the structure path already does.
Alternatives considered
Export both sides and diff the files.
Related database type
N/A / General
Problem
Compare & Sync compares structure. Two databases with the same schema and different rows compare as identical, so there is no way to see which rows differ or to generate the statements that would bring one in line with the other.
Proposed solution
Alternatives considered
Export both sides and diff the files.
Related database type
N/A / General