Data Comparison Report

PropertyValue
Report created03-Nov-2016 11:55
DTM Data Comparer build 1.26.05, build: Nov 3 2016, 11:55:05
Primary Database ConnectionSQL Server Native Client 11.0: .///NorthwindOriginal [Local Northwind DB]
DBMS and versionMicrosoft SQL Server [ 10.50.2550 ]
Secondary Database ConnectionSQL Server Native Client 11.0: .///t1 [Local Northwind DB]
DBMS and versionMicrosoft SQL Server [ 10.50.2550 ]

Comparison Results for table 'dbo.Customers' where Substring(CustomerID,1,1)<'D' and 'dbo.Customers'

Row #FieldsPrimary ValueSecondary Value
1CustomerIDALFKIALFKI
1CompanyNamePublix Super Markets Inc.Publix Super Markets Inc.
1ContactNameMaria Anders
1ContactTitleSales RepresentativeSales Representative
1AddressObere Str. 5742 Hills Trailer Court
1CityBerlinSunnyvale
1PostalCode1220912209
1CountryGermanyGermany
1Phone030-0074321(714) 277-8594
2CustomerIDANATRANATR
2CompanyNameCharter Communications Inc.Charter Communications Inc.
2ContactNameAna Trujilloda5iUURbO
2ContactTitleOwnerOwner
2AddressAvda. de la Constitución 22223738 East 98th Avenue
2CityMéxico D.F.Backtotop
2PostalCode0502105021
2CountryMexicoMexico
2Phone(5) 555-4729(021) 961-0952
3CustomerIDANTONANTON
3CompanyNameElectronic ArtsElectronic Arts
3ContactNameAntonio MorenodgRV7745beoai1bfNViiUZ
3ContactTitleOwnerOwner
3AddressMataderos 2312289 Pular Avenue
3CityMéxico D.F.Ayr
3PostalCode0502305023
3CountryMexicoMexico
3Phone(5) 555-3932(324) 041-0397
4CustomerIDAROUTAROUT
4CompanyNameNewmont Mining Corp.Newmont Mining Corp.
4ContactNameThomas HardycdbpkzWgmu4S
4ContactTitleSales RepresentativeSales Representative
4Address120 Hanover Sq.9 Carver Drive
4CityLondonWuppertal
4PostalCodeWA1 1DPWA1 1DP
4CountryUKUK
4Phone(171) 555-7788(697) 348-2153
5CustomerIDBERGS
5CompanyNameBerglunds snabbköp
5ContactNameChristina Berglund
5ContactTitleOrder Administrator
5AddressBerguvsvägen 8
5CityLuleå
5Region<NULL>
5PostalCodeS-958 22
5CountrySweden
5Phone0921-12 34 65
5Fax0921-12 34 67
6CustomerIDBLAUS
6CompanyNameBlauer See Delikatessen
6ContactNameHanna Moos
6ContactTitleSales Representative
6AddressForsterstr. 57
6CityMannheim
6Region<NULL>
6PostalCode68306
6CountryGermany
6Phone0621-08460
6Fax0621-08924
7CustomerIDBLONP
7CompanyNameBlondesddsl père et fils
7ContactNameFrédérique Citeaux
7ContactTitleMarketing Manager
7Address24, place Kléber
7CityStrasbourg
7Region<NULL>
7PostalCode67000
7CountryFrance
7Phone88.60.15.31
7Fax88.60.15.32
8CustomerIDBOLID
8CompanyNameBólido Comidas preparadas
8ContactNameMartín Sommer
8ContactTitleOwner
8AddressC/ Araquil, 67
8CityMadrid
8Region<NULL>
8PostalCode28023
8CountrySpain
8Phone(91) 555 22 82
8Fax(91) 555 91 99
9CustomerIDBONAP
9CompanyNameBon app'
9ContactNameLaurence Lebihan
9ContactTitleOwner
9Address12, rue des Bouchers
9CityMarseille
9Region<NULL>
9PostalCode13008
9CountryFrance
9Phone91.24.45.40
9Fax91.24.45.41
10CustomerIDBOTTM
10CompanyNameBottom-Dollar Markets
10ContactNameElizabeth Lincoln
10ContactTitleAccounting Manager
10Address23 Tsawassen Blvd.
10CityTsawassen
10RegionBC
10PostalCodeT2F 8M4
10CountryCanada
10Phone(604) 555-4729
10Fax(604) 555-3745
11CustomerIDBSBEV
11CompanyNameB's Beverages
11ContactNameVictoria Ashworth
11ContactTitleSales Representative
11AddressFauntleroy Circus
11CityLondon
11Region<NULL>
11PostalCodeEC2 5NT
11CountryUK
11Phone(171) 555-1212
11Fax<NULL>
12CustomerIDCACTU
12CompanyNameCactus Comidas para llevar
12ContactNamePatricio Simpson
12ContactTitleSales Agent
12AddressCerrito 333
12CityBuenos Aires
12Region<NULL>
12PostalCode1010
12CountryArgentina
12Phone(1) 135-5555
12Fax(1) 135-4892
13CustomerIDCENTC
13CompanyNameCentro comercial Moctezuma
13ContactNameFrancisco Chang
13ContactTitleMarketing Manager
13AddressSierras de Granada 9993
13CityMéxico D.F.
13Region<NULL>
13PostalCode05022
13CountryMexico
13Phone(5) 555-3392
13Fax(5) 555-7293
14CustomerIDCHOPS
14CompanyNameChop-suey Chinese
14ContactNameYang Wang
14ContactTitleOwner
14AddressHauptstr. 29
14CityBern
14Region<NULL>
14PostalCode3012
14CountrySwitzerland
14Phone0452-076545
14Fax<NULL>
15CustomerIDCOMMI
15CompanyNameComércio Mineiro
15ContactNamePedro Afonso
15ContactTitleSales Associate
15AddressAv. dos Lusíadas, 23
15CitySao Paulo
15RegionSP
15PostalCode05432-043
15CountryBrazil
15Phone(11) 555-7647
15Fax<NULL>
16CustomerIDCONSH
16CompanyNameConsolidated Holdings
16ContactNameElizabeth Brown
16ContactTitleSales Representative
16AddressBerkeley Gardens 12 Brewery
16CityLondon
16Region<NULL>
16PostalCodeWX1 6LT
16CountryUK
16Phone(171) 555-2282
16Fax(171) 555-9199

Statistics

PropertyValue
Rows in the primary table16
Rows in the secondary table4
Equal rows0 or 0.00 % of primary or 0.00 % of secondary
Different rows4 or 25.00 % of primary or 100.00 % of secondary
Orphan rows in the primary table12 or 75.00 % of primary
Orphan rows in the secondary table0 or 0.00 % of secondary
Column #1 'CustomerID' statistics4 values are equal, 0 values are different
Column #2 'CompanyName' statistics4 values are equal, 0 values are different
Column #3 'ContactName' statistics0 values are equal, 4 values are different
Column #4 'ContactTitle' statistics4 values are equal, 0 values are different
Column #5 'Address' statistics0 values are equal, 4 values are different
Column #6 'City' statistics0 values are equal, 4 values are different
Column #7 'PostalCode' statistics4 values are equal, 0 values are different
Column #8 'Country' statistics4 values are equal, 0 values are different
Column #9 'Phone' statistics0 values are equal, 4 values are different