Schema compare: Format sources before compare

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
rkwpt
Posts: 5
Joined: Fri 15 May 2020 09:43

Schema compare: Format sources before compare

Post by rkwpt » Tue 10 May 2022 14:23

Hello,

Wen are comparing a lot of triggers where the only differences come from different formats in the source (additional linefeeds, additional spaces at the end of the line). All these chages are marked as different which makes it very difficult to review the cmparision.

Is it possible to format the sources (on both sides formatting in the same way) to avoid such differences?

I have set the option "Ignore whitespace" in the options but it seems to have no effect.

We are using version 4.2.12 of the software.

Thanks in advance,
Ralf

dzhanhira
Devart Team
Posts: 194
Joined: Mon 26 Oct 2020 13:49

Re: Schema compare: Format sources before compare

Post by dzhanhira » Thu 12 May 2022 07:54

Hi Ralf,

Kindly be informed that you are using an old version of our product, please note that the latest version is 4.4.19

So we would like to ask you to update the version and check it on the latest one.

rkwpt
Posts: 5
Joined: Fri 15 May 2020 09:43

Re: Schema compare: Format sources before compare

Post by rkwpt » Fri 13 May 2022 13:48

Thanks for the tip.

With the new version, formatting is uniform before comparison. However, I still get some differences when there are extra line feeds in a file.

I will check again if I have set an option incorrectly.

wombatmarmalade
Posts: 1
Joined: Tue 28 Jun 2022 10:14

Re: Schema compare: Format sources before compare

Post by wombatmarmalade » Tue 28 Jun 2022 10:18

It's impossible to compare changes because they're all labeled different
foodle

dzhanhira
Devart Team
Posts: 194
Joined: Mon 26 Oct 2020 13:49

Re: Schema compare: Format sources before compare

Post by dzhanhira » Mon 04 Jul 2022 07:56

Hi,

Kindly be informed that we need additional information.

Please provide us with DDL triggers, screenshots of differences, and options with which you perform schema comparison.

Raghu251wer
Posts: 1
Joined: Fri 29 Jul 2022 12:32

Re: Schema compare: Format sources before compare

Post by Raghu251wer » Fri 29 Jul 2022 13:16

We are using version 4.2.12 of the software.

dzhanhira
Devart Team
Posts: 194
Joined: Mon 26 Oct 2020 13:49

Re: Schema compare: Format sources before compare

Post by dzhanhira » Wed 03 Aug 2022 06:00

Kindly note that we have v4.4.26 19-Jul-22, please inctall it and check on it.

If it still persists, please provide us with DDL triggers, screenshots of differences, and options with which you perform schema comparison.

kumar380kter
Posts: 1
Joined: Thu 04 Aug 2022 09:14

Re: Schema compare: Format sources before compare

Post by kumar380kter » Thu 04 Aug 2022 09:17

the options but it seems to have no effect.

Post Reply