Data Comparison Report

Header
Results
Statistics

Property	Value
Report created	03-Nov-2016 11:55
DTM Data Comparer build	1.26.05, build: Nov 3 2016, 11:55:05
Primary Database Connection	SQL Server Native Client 11.0: .///NorthwindOriginal [Local Northwind DB]
DBMS and version	Microsoft SQL Server [ 10.50.2550 ]
Secondary Database Connection	SQL Server Native Client 11.0: .///t1 [Local Northwind DB]
DBMS and version	Microsoft SQL Server [ 10.50.2550 ]

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

Row #	Fields	Primary Value	Secondary Value
1	CustomerID	ALFKI	ALFKI
1	CompanyName	Publix Super Markets Inc.	Publix Super Markets Inc.
1	ContactName	Maria Anders
1	ContactTitle	Sales Representative	Sales Representative
1	Address	Obere Str. 57	42 Hills Trailer Court
1	City	Berlin	Sunnyvale
1	PostalCode	12209	12209
1	Country	Germany	Germany
1	Phone	030-0074321	(714) 277-8594
2	CustomerID	ANATR	ANATR
2	CompanyName	Charter Communications Inc.	Charter Communications Inc.
2	ContactName	Ana Trujillo	da5iUURbO
2	ContactTitle	Owner	Owner
2	Address	Avda. de la Constitución 2222	3738 East 98th Avenue
2	City	México D.F.	Backtotop
2	PostalCode	05021	05021
2	Country	Mexico	Mexico
2	Phone	(5) 555-4729	(021) 961-0952
3	CustomerID	ANTON	ANTON
3	CompanyName	Electronic Arts	Electronic Arts
3	ContactName	Antonio Moreno	dgRV7745beoai1bfNViiUZ
3	ContactTitle	Owner	Owner
3	Address	Mataderos 2312	289 Pular Avenue
3	City	México D.F.	Ayr
3	PostalCode	05023	05023
3	Country	Mexico	Mexico
3	Phone	(5) 555-3932	(324) 041-0397
4	CustomerID	AROUT	AROUT
4	CompanyName	Newmont Mining Corp.	Newmont Mining Corp.
4	ContactName	Thomas Hardy	cdbpkzWgmu4S
4	ContactTitle	Sales Representative	Sales Representative
4	Address	120 Hanover Sq.	9 Carver Drive
4	City	London	Wuppertal
4	PostalCode	WA1 1DP	WA1 1DP
4	Country	UK	UK
4	Phone	(171) 555-7788	(697) 348-2153
5	CustomerID	BERGS
5	CompanyName	Berglunds snabbköp
5	ContactName	Christina Berglund
5	ContactTitle	Order Administrator
5	Address	Berguvsvägen 8
5	City	Luleå
5	Region	<NULL>
5	PostalCode	S-958 22
5	Country	Sweden
5	Phone	0921-12 34 65
5	Fax	0921-12 34 67
6	CustomerID	BLAUS
6	CompanyName	Blauer See Delikatessen
6	ContactName	Hanna Moos
6	ContactTitle	Sales Representative
6	Address	Forsterstr. 57
6	City	Mannheim
6	Region	<NULL>
6	PostalCode	68306
6	Country	Germany
6	Phone	0621-08460
6	Fax	0621-08924
7	CustomerID	BLONP
7	CompanyName	Blondesddsl père et fils
7	ContactName	Frédérique Citeaux
7	ContactTitle	Marketing Manager
7	Address	24, place Kléber
7	City	Strasbourg
7	Region	<NULL>
7	PostalCode	67000
7	Country	France
7	Phone	88.60.15.31
7	Fax	88.60.15.32
8	CustomerID	BOLID
8	CompanyName	Bólido Comidas preparadas
8	ContactName	Martín Sommer
8	ContactTitle	Owner
8	Address	C/ Araquil, 67
8	City	Madrid
8	Region	<NULL>
8	PostalCode	28023
8	Country	Spain
8	Phone	(91) 555 22 82
8	Fax	(91) 555 91 99
9	CustomerID	BONAP
9	CompanyName	Bon app'
9	ContactName	Laurence Lebihan
9	ContactTitle	Owner
9	Address	12, rue des Bouchers
9	City	Marseille
9	Region	<NULL>
9	PostalCode	13008
9	Country	France
9	Phone	91.24.45.40
9	Fax	91.24.45.41
10	CustomerID	BOTTM
10	CompanyName	Bottom-Dollar Markets
10	ContactName	Elizabeth Lincoln
10	ContactTitle	Accounting Manager
10	Address	23 Tsawassen Blvd.
10	City	Tsawassen
10	Region	BC
10	PostalCode	T2F 8M4
10	Country	Canada
10	Phone	(604) 555-4729
10	Fax	(604) 555-3745
11	CustomerID	BSBEV
11	CompanyName	B's Beverages
11	ContactName	Victoria Ashworth
11	ContactTitle	Sales Representative
11	Address	Fauntleroy Circus
11	City	London
11	Region	<NULL>
11	PostalCode	EC2 5NT
11	Country	UK
11	Phone	(171) 555-1212
11	Fax	<NULL>
12	CustomerID	CACTU
12	CompanyName	Cactus Comidas para llevar
12	ContactName	Patricio Simpson
12	ContactTitle	Sales Agent
12	Address	Cerrito 333
12	City	Buenos Aires
12	Region	<NULL>
12	PostalCode	1010
12	Country	Argentina
12	Phone	(1) 135-5555
12	Fax	(1) 135-4892
13	CustomerID	CENTC
13	CompanyName	Centro comercial Moctezuma
13	ContactName	Francisco Chang
13	ContactTitle	Marketing Manager
13	Address	Sierras de Granada 9993
13	City	México D.F.
13	Region	<NULL>
13	PostalCode	05022
13	Country	Mexico
13	Phone	(5) 555-3392
13	Fax	(5) 555-7293
14	CustomerID	CHOPS
14	CompanyName	Chop-suey Chinese
14	ContactName	Yang Wang
14	ContactTitle	Owner
14	Address	Hauptstr. 29
14	City	Bern
14	Region	<NULL>
14	PostalCode	3012
14	Country	Switzerland
14	Phone	0452-076545
14	Fax	<NULL>
15	CustomerID	COMMI
15	CompanyName	Comércio Mineiro
15	ContactName	Pedro Afonso
15	ContactTitle	Sales Associate
15	Address	Av. dos Lusíadas, 23
15	City	Sao Paulo
15	Region	SP
15	PostalCode	05432-043
15	Country	Brazil
15	Phone	(11) 555-7647
15	Fax	<NULL>
16	CustomerID	CONSH
16	CompanyName	Consolidated Holdings
16	ContactName	Elizabeth Brown
16	ContactTitle	Sales Representative
16	Address	Berkeley Gardens 12 Brewery
16	City	London
16	Region	<NULL>
16	PostalCode	WX1 6LT
16	Country	UK
16	Phone	(171) 555-2282
16	Fax	(171) 555-9199

Statistics

Property	Value
Rows in the primary table	16
Rows in the secondary table	4
Equal rows	0 or 0.00 % of primary or 0.00 % of secondary
Different rows	4 or 25.00 % of primary or 100.00 % of secondary
Orphan rows in the primary table	12 or 75.00 % of primary
Orphan rows in the secondary table	0 or 0.00 % of secondary
Column #1 'CustomerID' statistics	4 values are equal, 0 values are different
Column #2 'CompanyName' statistics	4 values are equal, 0 values are different
Column #3 'ContactName' statistics	0 values are equal, 4 values are different
Column #4 'ContactTitle' statistics	4 values are equal, 0 values are different
Column #5 'Address' statistics	0 values are equal, 4 values are different
Column #6 'City' statistics	0 values are equal, 4 values are different
Column #7 'PostalCode' statistics	4 values are equal, 0 values are different
Column #8 'Country' statistics	4 values are equal, 0 values are different
Column #9 'Phone' statistics	0 values are equal, 4 values are different