comparison using 7 columns

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

comparison using 7 columns

Post by talalhallaj » Thu 24 Dec 2020 12:38

Hello,
I use :
Postgres database, schema public.
dbForge Data Compare for PostgreSQL, standard Edition 3.3.6.

I want to compare 2 tables using a primary key consisting of seven columns.

Where I have mistaken?. Why dbForge does not recognize the primary key,
and Why do results change if I changed the order of column within the PK?

Here is an instance:

drop table if exists public.t_source;
commit;

create table public.t_source
(
f235_cg varchar(28) not null,
f235_ch varchar(16) not null,
f235_ci varchar(4) not null,
svs_schluesselart varchar(1) not null,
svs_mandant varchar(2) not null,
svs_gueltig_von varchar(8) not null,
svs_gueltig_bis varchar(8) not null,
svs_text varchar(199) null,
svs_sprache varchar(1) null,
constraint pk_source primary key (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)
);
commit;

insert into public.t_source (f235_cg,f235_ch,f235_ci,svs_schluesselart,svs_mandant,svs_gueltig_von,svs_gueltig_bis,svs_text,svs_sprache) values
('ZQZ-KARL-ART-STRG ','1 ','0020','C','01','19000101','29991231','Txt-Sarlehen ','D'),
('ZQZ-KARL-ART-STRG ','2 ','0020','C','01','19000101','29991231','Bakward-Sarlehen ','D')
;
commit;

drop table if exists public.t_target;
commit;

create table public.t_target
(
f235_cg varchar(28) not null,
f235_ch varchar(16) not null,
f235_ci varchar(4) not null,
svs_schluesselart varchar(1) not null,
svs_mandant varchar(2) not null,
svs_gueltig_von varchar(8) not null,
svs_gueltig_bis varchar(8) not null,
svs_text varchar(199) null,
svs_sprache varchar(1) null,
constraint pk_target primary key (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)
);
commit;

insert into public.t_target (f235_cg,f235_ch,f235_ci,svs_schluesselart,svs_mandant,svs_gueltig_von,svs_gueltig_bis,svs_text,svs_sprache) values
('ZQZ-KARL-ART-STRG ','L ','0020','C','01','20200304','29991231','Texte Freiheit ','D'),
('ZQZ-KARL-ART-STRG ','1 ','0020','C','01','19000101','29991231','Txt-Sarlehen ','D'),
('ZQZ-KARL-ART-STRG ','2 ','0020','C','01','19000101','29991231','Bakward-Sarlehen ','D')
;
commit;

The Comparative result from the CSV report is:
1. Report File
Devart dbForge Data Compare for PostgreSQL Report
Generated on 24.12.2020 at 11:07

"Source";;;"Target"
"Database";"postgres";;"Database";"postgres"
"Host";"xxx.xxx.xxx.xxx";;"Host";"xxx.xxx.xxx.xxx"
"Port";"5433";;"Port";"5433"
"Server version";"11.5";;"Server version";"11.5"

Comparison Results
"Object";"WHERE Filter";"Only in Source";"Different Records";"Only in Target";"Identical Records";
"vbg1_44561.t_source with vbg1_44561.t_target";"";"2";"0";"3";"0";
Total
"1";"";"2";"0";"3";"0";

2. the detials File:
Table t_source with t_target

Only in Source
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache";
"'ZQZ-KARL-ART-STRG '";"'0020'";"'1 '";"'C'";"'01'";"'19000101'";"'29991231'";"'Txt-Sarlehen '";"'D'";
"'ZQZ-KARL-ART-STRG '";"'0020'";"'2 '";"'C'";"'01'";"'19000101'";"'29991231'";"'Bakward-Sarlehen '";"'D'";

Only in Target
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache";
"'ZQZ-KARL-ART-STRG '";"'0020'";"'L '";"'C'";"'01'";"'20200304'";"'29991231'";"'Texte Freiheit '";"'D'";
"'ZQZ-KARL-ART-STRG '";"'0020'";"'1 '";"'C'";"'01'";"'19000101'";"'29991231'";"'Txt-Sarlehen '";"'D'";
"'ZQZ-KARL-ART-STRG '";"'0020'";"'2 '";"'C'";"'01'";"'19000101'";"'29991231'";"'Bakward-Sarlehen '";"'D'";

I copied the values to Excel file and I compared the results, every 2 columns (using If function),
there is just one row in target ,that has 'L ' in column f235_ch. And the rest are identical.

now:
I changed the order of the columns within the primary key (I shifted the two columns f235_cg and f235_ci to the last)
the result changed.

alter table public.t_source
drop constraint pk_source;
commit;

alter table public.t_source
add constraint pk_source primary key
(svs_gueltig_von, svs_gueltig_bis, f235_ch, svs_schluesselart, svs_mandant, f235_cg, f235_ci);
commit;

alter table public.t_target
drop constraint pk_target;
commit;

alter table public.t_target
add constraint pk_target primary key
(svs_gueltig_von, svs_gueltig_bis, f235_ch, svs_schluesselart, svs_mandant, f235_cg, f235_ci);
commit;

The Comparative result from the CSV report is:
1. Report File
Devart dbForge Data Compare for PostgreSQL Report
Generated on 24.12.2020 at 11:03

"Source";;;"Target"
"Database";"postgres";;"Database";"postgres"
"Host";"xxx.xxx.xxx.xxx";;"Host";"xxx.xxx.xxx.xxx"
"Port";"5433";;"Port";"5433"
"Server version";"11.5";;"Server version";"11.5"

Comparison Results file
"Object";"WHERE Filter";"Only in Source";"Different Records";"Only in Target";"Identical Records";
"vbg1_44561.t_source with vbg1_44561.t_target";"";"0";"0";"1";"2";
Total
"1";"";"0";"0";"1";"2";

2. the detials File:
Table t_source with t_target

Only in Target
"svs_gueltig_von";"svs_gueltig_bis";"f235_ch";"svs_schluesselart";"svs_mandant";"f235_cg";"f235_ci";"svs_text";"svs_sprache";
"'20200304'";"'29991231'";"'L '";"'C'";"'01'";"'ZQZ-KARL-ART-STRG '";"'0020'";"'Texte Freiheit '";"'D'";

Equal
"svs_gueltig_von";"svs_gueltig_bis";"f235_ch";"svs_schluesselart";"svs_mandant";"f235_cg";"f235_ci";"svs_text";"svs_sprache";
"'19000101'";"'29991231'";"'1 '";"'C'";"'01'";"'ZQZ-KARL-ART-STRG '";"'0020'";"'Txt-Sarlehen '";"'D'";
"'19000101'";"'29991231'";"'2 '";"'C'";"'01'";"'ZQZ-KARL-ART-STRG '";"'0020'";"'Bakward-Sarlehen '";"'D'";

Thanks for your response

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

Re: comparison using 7 columns

Post by dzhanhira » Tue 12 Jan 2021 09:15

It seems that you have incorrectly mapped tables. if everything is done correctly, then the primary key is mapped automatically.

In the Mapping window, select all objects in the table by clicking on the first row of the table and Shift + clicking on the last row of the table, and then Unmap.

Please send the screen of the result that you received.

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Tue 12 Jan 2021 14:05

for the first example from above, the primary key (pk_source , pk_target) has the ordered columns
(f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis).
the mapped tables :
Image
the result:
Image
and
Image
for the second example, I changed the columns order, the primary key (pk_source , pk_target)  has new ordered columns
(svs_gueltig_von, svs_gueltig_bis, f235_ch, svs_schluesselart, svs_mandant, f235_cg, f235_ci).
the mapped tables as is, and the result:
Image
and
Image

earliest attention would be appreciated
Many thanks.

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

Re: comparison using 7 columns

Post by dzhanhira » Thu 14 Jan 2021 15:29

According to your initial data, we do not get the result as in the first picture. Could you please provide a video of how you do this, it would help.

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

Re: comparison using 7 columns

Post by dzhanhira » Fri 15 Jan 2021 11:31

Also could you please send system settings and server version on which it is happened.

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Tue 19 Jan 2021 10:50

I uploaded the video to Youtube, this is the link : https://youtu.be/qRMDDuHd9Cs
server version : Windows Server 2012 R2
system settings : Could you please be more specific, wich system settings you need?

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

Re: comparison using 7 columns

Post by dzhanhira » Fri 22 Jan 2021 11:18

Could you please go to:
Help -> About -> View System Info
And send to us that information

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Fri 22 Jan 2021 17:32

=========================
General
=========================
Application: dbForge Data Compare for PostgreSQL
Product: Devart dbForge Data Compare for PostgreSQL
Product Edition: Standard
Product Locale: English
Trial Info: Activated
HardwareID: AFB0-98C7-C53C-0140-E894
Assembly: datacompare, Version=3.3.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Data Compare for PostgreSQL\datacompare.exe
Global cache: False
Framework: 4.6.2 or later
=========================
Window Layout
=========================
Active document window: 'TPPB4142-QRY.dcomp*' (Compare)
Active window: 'TPPB4142-QRY.dcomp*'
Active document 'TPPB4142-QRY.dcomp'

Documents:
Name: 'TPPB4142-QRY.dcomp', Caption: 'TPPB4142-QRY.dcomp*', Visible: True, Active view: 'Compare', Initial view: 'Compare'

Toolwindows (visible or have been shown in current session):
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed

=========================
Connections
=========================
DEV2 - 'User Id=techuser;Host=10.200.57.65;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Sandbox
10.200.33.36 - 'User Id=postgres;Host=10.200.33.36;Port=5433;Database=talal;Unicode=True;Integrated Security=False'
tpbd_dev.10.200.57.65 - 'User Id=techuser;Host=10.200.57.65;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Sandbox
tpbd_dev.tpbd-db.cfs-p1257-stage.staging.k8s.lan - 'User Id=techuser;Host=tpbd-db.cfs-p1257-stage.staging.k8s.lan;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Sandbox
tpbd_dev_20190201_2_AT_10.200.33.101 - 'User Id=techuser;Host=10.200.33.101;Database=tpbd_dev_20190201_2;Unicode=True;Integrated Security=False'
tpbd_dev_AT_10.200.33.101:5433 - 'User Id=techuser;Host=10.200.33.101;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False'
db_ServiceLog_94th_port_5432 - 'User Id=techuser;Host=10.200.33.94;Database=services_log;Unicode=True;Integrated Security=False'
services_log_on_10.200.33.94 - 'User Id=techuser;Host=10.200.33.94;Database=services_log;Unicode=True;Integrated Security=False'
services_log.10.200.33.94 - 'User Id=techuser;Host=10.200.33.94;Database=services_log;Unicode=True;Integrated Security=False'
CMP_POST_TPBD-4526 - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
SIB_POST_TPBD-4526 - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
CMP_POST_vs_SIB_POST_Test2_TPBD-4526 - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT4525-CMP_POST - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT4525-SIB_POST - 'User Id=techuser;Host=10.200.43.144;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT4528-SIB_POST - 'User Id=techuser;Host=10.200.43.144;Port=5434;Database=tpbd_dev;Unicode=True;Integrated Security=False'
JT4528-CMP_POST - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT4142-CMP_PRE - 'User Id=techuser;Host=jcl01-compute.infra.in.comparus.de;Port=50000;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT4142_SIB_Without_PostOrPre (open) - 'User Id=techuser;Host=10.200.43.144;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False'. Server version: PostgreSQL 11.5 (Debian 11.5-3.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit Category: Test
JT-PLATFORM-3899-schema-Fach_Abstimm - 'User Id=techuser;Host=jcl01-compute.infra.in.comparus.de;Port=50000;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT-PLATFORM3899-Fach_bstimm_20201116 - 'User Id=techuser;Host=jcl01-compute.infra.in.comparus.de;Port=50000;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT_TPBD_4997_CMP_POST - 'User Id=techuser;Host=10.200.43.144;Port=5437;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT_TPBD_4997_SIB_POST - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
CMP_PRE_original - 'User Id=techuser;Host=jcl01-compute.infra.in.comparus.de;Port=50000;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Sandbox
CMP_POST_JT4997 - 'User Id=techuser;Host=10.200.43.144;Port=5437;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Sandbox
CMP_PRE_CLONE (open) - 'User Id=techuser;Host=10.200.43.144;Port=5555;Database=tpbd_dev;Unicode=True;Integrated Security=False'. Server version: PostgreSQL 11.5 (Debian 11.5-3.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit Category: Sandbox
JT_TPBD_4997_SIB_POST_1 - 'User Id=techuser;Host=10.200.43.144;Port=5439;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
CMP_POST_JT_TPBD_4528 - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
CMP_POST_JT_TPBD_4997 - 'User Id=techuser;Host=10.200.43.144;Port=5437;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
CMP_POST_JT_TPBD_4997_try02 - 'User Id=techuser;Host=10.200.43.144;Port=5439;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT_TPBD_4528_CMP_POST_try02 - 'User Id=techuser;Host=10.200.43.144;Port=5438;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT_TPBD_4528_SIB_POST - 'User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
JT_TPBD_CMP_POST_5042 - 'User Id=techuser;Host=10.200.43.144;Port=5439;Database=tpbd_dev;Unicode=True;Integrated Security=False' Category: Test
Source - 'User Id=techuser;Host=10.200.43.144;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False'
Target - 'User Id=techuser;Host=10.200.43.144;Port=5433;Database=tpbd_dev;Unicode=True;Integrated Security=False'

=========================
Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
datacompare, Version=3.3.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.3.6.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/datacompare.exe
Devart.Shell.Studio, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Studio.DLL
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
Devart.Shell.Interfaces, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Interfaces.DLL
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
Devart.Shell.Common, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Common.DLL
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
DevExpress.XtraEditors.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.XtraEditors.v13.2.DLL
DevExpress.Utils.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.Utils.v13.2.DLL
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll
mscorlib.resources, Version=4.0.0.0, Culture=de, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_de_b77a5c561934e089/mscorlib.resources.dll
Devart.Shell.Resources, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Resources.DLL
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
Devart.Shell.IocService, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.IocService.DLL
Autofac, Version=4.2.1.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.2.1.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Autofac.DLL
DevExpress.Data.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.Data.v13.2.DLL
DevExpress.XtraBars.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.XtraBars.v13.2.DLL
Devart.Shell.Controls, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Controls.DLL
Newtonsoft.Json, Version=9.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed 9.0.0.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Newtonsoft.Json.DLL
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
Microsoft.VisualStudio.Diagnostics.ServiceModelSink, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Diagnostics.ServiceModelSink/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Diagnostics.ServiceModelSink.dll
System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll
System.IdentityModel.Selectors, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel.Selectors/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.Selectors.dll
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
Devart.DbForge.Resources, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Resources.DLL
DevExpress.Xpf.Core.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.Xpf.Core.v13.2.DLL
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsFormsIntegration/v4.0_4.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
PresentationFramework.AeroLite, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework.AeroLite/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.AeroLite.dll
System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
PresentationFramework-SystemXml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXml/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXml.dll
PresentationFramework-SystemXmlLinq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXmlLinq/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXmlLinq.dll
Devart.DbForge.Resources.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Resources.PostgreSql.DLL
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll
UIAutomationProvider, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
System.ComponentModel.Composition, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll
DevExpress.XtraGrid.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.XtraGrid.v13.2.DLL
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
Devart.Shell.TextEditor.Interfaces, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.TextEditor.Interfaces.DLL
Devart.DbForge.Utils, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Utils.DLL
Devart.DbForge.Interfaces, Version=4.0.84.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.84.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Interfaces.DLL
Devart.DbForge.Common.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Common.PostgreSql.DLL
DevExpress.Xpf.Mvvm.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.Xpf.Mvvm.v13.2.DLL
System.ComponentModel.DataAnnotations, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.DataAnnotations/v4.0_4.0.0.0__31bf3856ad364e35/System.ComponentModel.DataAnnotations.dll
DevExpress.Xpf.Themes.Office2013DarkGray.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.Xpf.Themes.Office2013DarkGray.v13.2.DLL
PresentationFramework-SystemData, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemData/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemData.dll
Devart.DbForge.CommonServices, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.CommonServices.DLL
Devart.DbForge.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.PostgreSql.DLL
Devart.DbForge.Provider, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Provider.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.22.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Data.Interfaces.DLL
Devart.DbForge.Data.PostgreSql, Version=6.1.133.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.133.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Data.PostgreSql.DLL
Devart.DbForge.DbObjects, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjects.DLL
Devart.DbForge.Compare.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Compare.PostgreSql.DLL
Devart.DbForge.Compare, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Compare.DLL
Devart.DbForge.UI, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.UI.DLL
Devart.DbForge.DataEditor, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DataEditor.DLL
DevExpress.XtraPrinting.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/DevExpress.XtraPrinting.v13.2.DLL
Devart.DbForge.LanguageService.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.LanguageService.PostgreSql.DLL
Devart.DbForge.LanguageService, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.LanguageService.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Antlr3.Runtime.DLL
Devart.DbForge.DbObjects.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjects.PostgreSql.DLL
Devart.DbForge.DbObjectModels.Controllers.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjectModels.Controllers.PostgreSql.DLL
Devart.DbForge.DbObjectModels.Controllers, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjectModels.Controllers.DLL
Devart.DbForge.DbObjectModels.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjectModels.PostgreSql.DLL
Devart.DbForge.DbObjectModels, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DbObjectModels.DLL
Devart.Ole.UndoManager, Version=1.0.1352.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.1352.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Ole.UndoManager.DLL
Devart.Shell.TextEditor, Version=2.1.21.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.21.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.TextEditor.DLL
Devart.DbForge.Repository, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Repository.DLL
ParallelExtensionsExtras, Version=1.2.3.0, Culture=neutral, PublicKeyToken=665f4d61f853b5a9 1.2.3.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/ParallelExtensionsExtras.DLL
Devart.DbForge.Repository.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.Repository.PostgreSql.DLL
System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.Shell.Common.dll
Devart.DbForge.DataExport, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.DataExport.DLL
Devart.DbForge.CompoundFile, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.CompoundFile.DLL
Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c 1.9.1.8 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Ionic.Zip.DLL
Devart.DbForge.TextComparer, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.TextComparer.DLL
Devart.DbForge.SchemaExport.PostgreSql, Version=1.0.343.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.343.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.SchemaExport.PostgreSql.DLL
Devart.DbForge.SchemaExport, Version=6.1.874.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.874.0 C:/Program Files/Devart/dbForge Data Compare for PostgreSQL/Devart.DbForge.SchemaExport.DLL

=========================
System Information
=========================
Processor architecture: amd64
Processor quantity: 16
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2
Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Intel64 Family 6 Model 44 Stepping 2

Total physical memory: 65523Mb
Total available paginal memory: 70650Mb
Process available virtual memory: 134216173Mb
Process private memory size: 786Mb
Display1: 2048x1152, 100% DPI

Operating System Name: Windows Server 2012 R2 Standard
Operating System Version: Microsoft Windows NT 6.3.9600.0
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: False
Is process elevated: False
Elevation type: Limited
Integrity level: Medium

Instances: 1
Culture: German (Germany)
Process started at 01/18/2021 20:36:53
Report created at 01/22/2021 13:54:51

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

Re: comparison using 7 columns

Post by dzhanhira » Tue 26 Jan 2021 11:14

Thank you for provided information. We will investigate the problem and come back to you as soon as possible.

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

Re: comparison using 7 columns

Post by dzhanhira » Thu 28 Jan 2021 08:06

We believe that the problem arises when forming a unique index, but at the moment we have not been able to repeat the behavior.
Can you repeat the problem in a new database (created according to your own scripts) and send us the dcomp comparison template file for further analysis?

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Fri 29 Jan 2021 15:32

I created a new database with two tables (t_source , t_target as in the example above)
in public schema 
Note: 
more information about the database:
  • Default Encoding : UTF8
  • Collate : cp273.UTF-8
  • Ctype : cp273.UTF-8
here is the dcomp file :

---------------------
<?xml version="1.0" encoding="utf-8"?>
<!-- Devart (www.devart.com), compare document file -->
<!-- Modifying this generated file will probably render it invalid -->
<CompareDocument>
<Properties>
<DatabaseProvider>77a9b459-6f15-4675-8e18-cdd88f58e376</DatabaseProvider>
<ProviderVersion>1.0.343.0</ProviderVersion>
<SchemaVersion>2.0</SchemaVersion>
</Properties>
<Source Type="Database">
<DataConnection>test_PK_Porblem_collatrion</DataConnection>
<ConnectionString>User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=db0;Unicode=True;Integrated Security=False</ConnectionString>
<Category>02f94b89-0b27-4fef-8284-e4c5dd9af3b1</Category>
<Schema>db0</Schema>
</Source>
<Target Type="Database">
<DataConnection>test_PK_Porblem_collatrion</DataConnection>
<ConnectionString>User Id=techuser;Host=pg01.dev.comparus.de;Port=5433;Database=db0;Unicode=True;Integrated Security=False</ConnectionString>
<Category>02f94b89-0b27-4fef-8284-e4c5dd9af3b1</Category>
<Schema>db0</Schema>
</Target>
<Filter Value="0" />
<HideUnmodifiedColumns>False</HideUnmodifiedColumns>
<Options>
<PropertyValue Name="IgnoreBlobColumns">false</PropertyValue>
<PropertyValue Name="IgnoreSerialColumns">true</PropertyValue>
<PropertyValue Name="MappingIgnoreSpaces">true</PropertyValue>
<PropertyValue Name="HideSystemSchemas">false</PropertyValue>
<PropertyValue Name="MappingIgnoreCase">false</PropertyValue>
<PropertyValue Name="MappingIgnoreUnderscores">false</PropertyValue>
<PropertyValue Name="IgnoreColumnsByMask">false</PropertyValue>
<PropertyValue Name="MappingColumnsMask" xml:space="preserve">*ModifiedDate*,*CreatedOn*,*UpdatedBy*</PropertyValue>
<PropertyValue Name="ExcludeObjectsByMask">false</PropertyValue>
<PropertyValue Name="ExcludeObjectsMask" xml:space="preserve">*Table*</PropertyValue>
<PropertyValue Name="IncludeObjectsByMask">false</PropertyValue>
<PropertyValue Name="IncludeObjectsMask" xml:space="preserve">*</PropertyValue>
<PropertyValue Name="CompareTables">true</PropertyValue>
<PropertyValue Name="CompareViews">false</PropertyValue>
<PropertyValue Name="RoundFloatTypes">false</PropertyValue>
<PropertyValue Name="RoundFloatTypesUpTo" xml:space="preserve">3</PropertyValue>
<PropertyValue Name="IgnoreLeadingSpaces">false</PropertyValue>
<PropertyValue Name="IgnoreTrailingSpaces">false</PropertyValue>
<PropertyValue Name="IgnoreCase">false</PropertyValue>
<PropertyValue Name="IgnoreEndOfLine">false</PropertyValue>
<PropertyValue Name="IsEmptyStringEqualsNull">false</PropertyValue>
<PropertyValue Name="IsIgnoreTime">true</PropertyValue>
<PropertyValue Name="CheckDifferent">true</PropertyValue>
<PropertyValue Name="CheckOnlyInSource">true</PropertyValue>
<PropertyValue Name="CheckOnlyInTarget">true</PropertyValue>
<PropertyValue Name="CheckIdentical">true</PropertyValue>
</Options>
<ModifiedObjects />
<SynchronizationOptions>
<PropertyValue Name="DisableRules">false</PropertyValue>
<PropertyValue Name="BulkInsert">true</PropertyValue>
<PropertyValue Name="DropCheckConstraints">false</PropertyValue>
<PropertyValue Name="DisableForeignKeys">true</PropertyValue>
<PropertyValue Name="DisableDmlTriggers">true</PropertyValue>
<PropertyValue Name="DropKeys">false</PropertyValue>
<PropertyValue Name="CheckConcurrencyUpdates">false</PropertyValue>
<PropertyValue Name="ExcludeComments">false</PropertyValue>
<PropertyValue Name="ExecuteAsSingleTransaction">true</PropertyValue>
<PropertyValue Name="SynchronizeViaFiles">false</PropertyValue>
<PropertyValue Name="ExecuteCustomScriptTypeBefore">0</PropertyValue>
<PropertyValue Name="EmbeddedScriptBefore" xml:space="preserve" />
<PropertyValue Name="ExternalScriptBefore" xml:space="preserve" />
<PropertyValue Name="ExecuteCustomScriptTypeAfter">0</PropertyValue>
<PropertyValue Name="IncludeStatementUSEBefore">false</PropertyValue>
<PropertyValue Name="EmbeddedScriptAfter" xml:space="preserve" />
<PropertyValue Name="ExternalScriptAfter" xml:space="preserve" />
<PropertyValue Name="IncludeStatementUSEAfter">false</PropertyValue>
<PropertyValue Name="GenerateScriptHeader">true</PropertyValue>
<PropertyValue Name="SynchronizeType">2</PropertyValue>
<PropertyValue Name="SynchronizationFileName" xml:space="preserve" />
<PropertyValue Name="SynchronizationEditorFileName" xml:space="preserve" />
<PropertyValue Name="OpenScriptInEditor">false</PropertyValue>
<PropertyValue Name="RefreshAfterSynchronization">false</PropertyValue>
<PropertyValue Name="OpenScriptsFolder">false</PropertyValue>
<PropertyValue Name="PureScript">false</PropertyValue>
<PropertyValue Name="CommitPageLength" xml:space="preserve">0</PropertyValue>
</SynchronizationOptions>
<Mapping>
<Schemas>
<Object SourceName="public" TargetName="public" State="DefaultMapped" Included="False" />
</Schemas>
<ComparedObjects>
<Object SourceName="public.t_source" TargetName="public.t_target" SourceType="Table" TargetType="Table" CustomMapped="True" />
</ComparedObjects>
</Mapping>
</CompareDocument>
---------------------

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

Re: comparison using 7 columns

Post by dzhanhira » Mon 01 Feb 2021 15:26

Thank you for provided information.

Before performing data comparison leading to incorrect results, it rebuilds the primary key as seen on 7 key columns.

Could you please execute two scripts SPT-2609 Get Column Numbers (Constraint) .sql and SPT-2609 Get Column Numbers (Index) .sql after rebuild primary key and send the results (you can export from data editor to html or other format).

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

Re: comparison using 7 columns

Post by dzhanhira » Mon 08 Feb 2021 07:51

Sorry, for some reasons the files were not attached.
https://drive.google.com/drive/folders/ ... sp=sharing

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Mon 08 Feb 2021 15:16

If I have understood correctly,
you need information about : 
the constraint and their columns (or columns numbers)
the index and their columns (or columns numbers)
I executed two SQL statements from dbForge environment
and the results :

constraint columns for (t_source , t_target) :
"table_schema";"table_name";"constraint_name";"position";"key_column"
"public";"t_source";"pk_source";1;"f235_cg"
"public";"t_source";"pk_source";2;"f235_ci"
"public";"t_source";"pk_source";3;"f235_ch"
"public";"t_source";"pk_source";4;"svs_schluesselart"
"public";"t_source";"pk_source";5;"svs_mandant"
"public";"t_source";"pk_source";6;"svs_gueltig_von"
"public";"t_source";"pk_source";7;"svs_gueltig_bis"
"public";"t_target";"pk_target";1;"f235_cg"
"public";"t_target";"pk_target";2;"f235_ci"
"public";"t_target";"pk_target";3;"f235_ch"
"public";"t_target";"pk_target";4;"svs_schluesselart"
"public";"t_target";"pk_target";5;"svs_mandant"
"public";"t_target";"pk_target";6;"svs_gueltig_von"
"public";"t_target";"pk_target";7;"svs_gueltig_bis"

index columns for (t_source , t_target) :
"table_name";"index_name";"column_name"
"t_source";"pk_source";"f235_cg"
"t_source";"pk_source";"f235_ch"
"t_source";"pk_source";"f235_ci"
"t_source";"pk_source";"svs_schluesselart"
"t_source";"pk_source";"svs_mandant"
"t_source";"pk_source";"svs_gueltig_von"
"t_source";"pk_source";"svs_gueltig_bis"
"t_target";"pk_target";"f235_cg"
"t_target";"pk_target";"f235_ch"
"t_target";"pk_target";"f235_ci"
"t_target";"pk_target";"svs_schluesselart"
"t_target";"pk_target";"svs_mandant"
"t_target";"pk_target";"svs_gueltig_von"
"t_target";"pk_target";"svs_gueltig_bis"

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Mon 08 Feb 2021 16:31

Sorry, 
I had created and executed two SQL script, because I couldn't see your scripts before.
So, the previous results from my SQL statements.

And your SQL results are as follows: 
SPT-2609 Get Column Numbers (Constraint).sql
"object_name";"schema_name";"constr_type";"defferable";"deffered";"column_numbers";"table_name";"constr_rel_index";"constr_rel_index_schema";"constr_rel_index_table";"definition"
"pk_source";"public";"p";false;false;"{1,3,2,4,5,6,7}";"t_source";"pk_source";"public";"t_source";"PRIMARY KEY (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)"
"pk_target";"public";"p";false;false;"{1,3,2,4,5,6,7}";"t_target";"pk_target";"public";"t_target";"PRIMARY KEY (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)"
SPT-2609 Get Column Numbers (Index).sql
"object_name";"schema_name";"table_name";"is_unique";"is_primary";"column_numbers";"definition"
"pk_source";"public";"t_source";true;true;"1,3,2,4,5,6,7";"CREATE UNIQUE INDEX pk_source ON public.t_source USING btree (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)"
"pk_target";"public";"t_target";true;true;"1,3,2,4,5,6,7";"CREATE UNIQUE INDEX pk_target ON public.t_target USING btree (f235_cg, f235_ci, f235_ch, svs_schluesselart, svs_mandant, svs_gueltig_von, svs_gueltig_bis)"

Post Reply