comparison using 7 columns
Posted: Thu 24 Dec 2020 12:38
by talalhallaj
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
Re: comparison using 7 columns
Posted: Fri 22 Jan 2021 17:32
by talalhallaj
=========================
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
Re: comparison using 7 columns
Posted: Fri 29 Jan 2021 15:32
by talalhallaj
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:
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>
---------------------
Re: comparison using 7 columns
Posted: Mon 08 Feb 2021 16:31
by talalhallaj
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)"