Page 1 of 1

Bug report

Posted: Fri 28 Jan 2022 12:29
by pkExec
Thanks for the great product. Some bugs I found.

Comparing done between:
PostgreSQL version 11 and PostgreSQL version 13
dbForge Schema Compare version: 1.2.182 (Windows)

Bugs found:
- Sequences are not compared at all.
- Foreign keys are not detected as "different" if their only difference is at the action level ("ON DELETE CASCADE" for example).

Re: Bug report

Posted: Fri 28 Jan 2022 14:54
by pkExec
#3 - If the Foreign Keys are missing in the second database, then the script generated has "ON DELETE NO ACTION ON UPDATE NO ACTION", even if the original is not set this way (e.g. it's ON DELETE CASCADE)

Re: Bug report

Posted: Mon 31 Jan 2022 11:51
by alexa
This is to be implemented in one of the next product versions.

Re: Bug report

Posted: Tue 09 Aug 2022 09:08
by wardrose2
I also look forward to the next products . Hopefully it will have new breakthroughs.