Source project (left):AdventureWorks.sqlproj
Target database (right):[.\SQL11].[AdventureWorks_PRODUCTION]
Path:C:\BuildAgent\work\8d14ea28c3031417\db\AdventureWorks\AdventureWorks.sqlproj
Date generated:2013-04-22 22:56:54

Selected Report Options:

XDifferent Objects
 Equal Objects
XSource Only Objects
XDestination Only Objects
Objects specified by "ExcludeObjectsFromImport" property

Comparison Results By Object:

Tables

Name Schema In Source In Destination Diff Type View SQL
Person Person X X <> View SQL

Differences By Object:


Table [Person].[Person]//[Person].[Person] (back to Summary)
Source projectTarget database
1SET ANSI_NULLS ON1SET ANSI_NULLS ON
2SET QUOTED_IDENTIFIER ON2SET QUOTED_IDENTIFIER ON
33
4GO4GO
5CREATE TABLE [Person].[Person] (5CREATE TABLE [Person].[Person] (
6 [BusinessEntityID] [int] NOT NULL,6 [BusinessEntityID] [int] NOT NULL,
7 [PersonType] [nchar](2) NOT NULL,7 [PersonType] [nchar](2) NOT NULL,
8 [NameStyle] [dbo].[NameStyle] NOT NULL,8 [NameStyle] [dbo].[NameStyle] NOT NULL,
9 [Title] [nvarchar](8) NULL,9 [Title] [nvarchar](8) NULL,
10 [FirstName] [dbo].[Name] NOT NULL,10 [FirstName] [dbo].[Name] NOT NULL,
11 [MiddleName] [dbo].[Name] NULL,11 [MiddleName] [dbo].[Name] NULL,
12 [LastName] [dbo].[Name] NOT NULL,12 [LastName] [dbo].[Name] NOT NULL,
13 [Suffix] [nvarchar](10) NULL,13 [Suffix] [nvarchar](10) NULL,
14 [EmailPromotion] [int] NOT NULL,14 [EmailPromotion] [int] NOT NULL,
15 [AdditionalContactInfo] [xml](CONTENT [Person].[AdditionalContactInfoSchemaCollection]) NULL,15 [AdditionalContactInfo] [xml](CONTENT [Person].[AdditionalContactInfoSchemaCollection]) NULL,
16 [Demographics] [xml](CONTENT [Person].[IndividualSurveySchemaCollection]) NULL,16 [Demographics] [xml](CONTENT [Person].[IndividualSurveySchemaCollection]) NULL,
17 [rowguid] [uniqueidentifier] NOT NULL ROWGUIDCOL,17 [rowguid] [uniqueidentifier] NOT NULL ROWGUIDCOL,
18 [ModifiedDate] [datetime] NOT NULL18 [ModifiedDate] [datetime] NOT NULL
19) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]19) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
20GO20GO
21ALTER TABLE [Person].[Person]21ALTER TABLE [Person].[Person]
22 ADD22 ADD
23 CONSTRAINT [PK_Person_BusinessEntityID]23 CONSTRAINT [PK_Person_BusinessEntityID]
24 PRIMARY KEY24 PRIMARY KEY
25 CLUSTERED25 CLUSTERED
26 ([BusinessEntityID])26 ([BusinessEntityID])
27 ON [PRIMARY]27 ON [PRIMARY]
28GO28GO
29ALTER TABLE [Person].[Person]29ALTER TABLE [Person].[Person]
30 ADD30 ADD
31 CONSTRAINT [CK_Person_EmailPromotion]31 CONSTRAINT [CK_Person_EmailPromotion]
32 CHECK32 CHECK
33 ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))33 ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
34GO34GO
35ALTER TABLE [Person].[Person]35ALTER TABLE [Person].[Person]
36CHECK CONSTRAINT [CK_Person_EmailPromotion]36CHECK CONSTRAINT [CK_Person_EmailPromotion]
37GO37GO
38ALTER TABLE [Person].[Person]38ALTER TABLE [Person].[Person]
39 ADD39 ADD
40 CONSTRAINT [CK_Person_PersonType]40 CONSTRAINT [CK_Person_PersonType]
41 CHECK41 CHECK
42 ([PersonType] IS NULL OR (upper([PersonType])='GC' OR upper([PersonType])='SP' OR upper([PersonType])='EM' OR upper([PersonType])='IN' OR upper([PersonType])='VC' OR upper([PersonType])='SC'))42 ([PersonType] IS NULL OR (upper([PersonType])='GC' OR upper([PersonType])='SP' OR upper([PersonType])='EM' OR upper([PersonType])='IN' OR upper([PersonType])='VC' OR upper([PersonType])='SC'))
43GO43GO
44ALTER TABLE [Person].[Person]44ALTER TABLE [Person].[Person]
45CHECK CONSTRAINT [CK_Person_PersonType]45CHECK CONSTRAINT [CK_Person_PersonType]
46GO46GO
47ALTER TABLE [Person].[Person]47ALTER TABLE [Person].[Person]
48 ADD48 ADD
49 CONSTRAINT [DF_Person_EmailPromotion]49 CONSTRAINT [DF_Person_EmailPromotion]
50 DEFAULT ((0)) FOR [EmailPromotion]50 DEFAULT ((0)) FOR [EmailPromotion]
51GO51GO
52ALTER TABLE [Person].[Person]52ALTER TABLE [Person].[Person]
53 ADD53 ADD
54 CONSTRAINT [DF_Person_ModifiedDate]54 CONSTRAINT [DF_Person_ModifiedDate]
55 DEFAULT (getdate()) FOR [ModifiedDate]55 DEFAULT (getdate()) FOR [ModifiedDate]
56GO56GO
57ALTER TABLE [Person].[Person]57ALTER TABLE [Person].[Person]
58 ADD58 ADD
59 CONSTRAINT [DF_Person_NameStyle]59 CONSTRAINT [DF_Person_NameStyle]
60 DEFAULT ((0)) FOR [NameStyle]60 DEFAULT ((0)) FOR [NameStyle]
61GO61GO
62ALTER TABLE [Person].[Person]62ALTER TABLE [Person].[Person]
63 ADD63 ADD
64 CONSTRAINT [DF_Person_rowguid]64 CONSTRAINT [DF_Person_rowguid]
65 DEFAULT (newid()) FOR [rowguid]65 DEFAULT (newid()) FOR [rowguid]
66GO66GO
67ALTER TABLE [Person].[Person]67ALTER TABLE [Person].[Person]
68 WITH CHECK68 WITH CHECK
69 ADD CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID]69 ADD CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID]
70 FOREIGN KEY ([BusinessEntityID]) REFERENCES [Person].[BusinessEntity] ([BusinessEntityID])70 FOREIGN KEY ([BusinessEntityID]) REFERENCES [Person].[BusinessEntity] ([BusinessEntityID])
71ALTER TABLE [Person].[Person]71ALTER TABLE [Person].[Person]
72 CHECK CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID]72 CHECK CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID]
7373
74GO74GO
75CREATE UNIQUE NONCLUSTERED INDEX [AK_Person_rowguid]75CREATE UNIQUE NONCLUSTERED INDEX [AK_Person_rowguid]
76 ON [Person].[Person] ([rowguid])76 ON [Person].[Person] ([rowguid])
77 ON [PRIMARY]77 ON [PRIMARY]
78GO78GO
79CREATE NONCLUSTERED INDEX [IX_Person_LastName_FirstName_MiddleName]79CREATE NONCLUSTERED INDEX [IX_Person_LastName_FirstName_MiddleName]
80 ON [Person].[Person] ([LastName], [FirstName], [MiddleName])80 ON [Person].[Person] ([LastName], [FirstName], [MiddleName])
81 ON [PRIMARY]81 ON [PRIMARY]
  82GO
  83CREATE NONCLUSTERED INDEX [IX_Person_ModifiedDate]
  84 ON [Person].[Person] ([ModifiedDate] DESC)
  85 ON [PRIMARY]
82GO86GO
83CREATE PRIMARY XML INDEX [PXML_Person_AddContact]87CREATE PRIMARY XML INDEX [PXML_Person_AddContact]
84 ON [Person].[Person] ([AdditionalContactInfo])88 ON [Person].[Person] ([AdditionalContactInfo])
85GO89GO
86CREATE PRIMARY XML INDEX [PXML_Person_Demographics]90CREATE PRIMARY XML INDEX [PXML_Person_Demographics]
87 ON [Person].[Person] ([Demographics])91 ON [Person].[Person] ([Demographics])
88GO92GO
89CREATE XML INDEX [XMLPATH_Person_Demographics]93CREATE XML INDEX [XMLPATH_Person_Demographics]
90 ON [Person].[Person] ([Demographics])94 ON [Person].[Person] ([Demographics])
91 USING XML INDEX [PXML_Person_Demographics]95 USING XML INDEX [PXML_Person_Demographics]
92 FOR PATH96 FOR PATH
93GO97GO
94CREATE XML INDEX [XMLPROPERTY_Person_Demographics]98CREATE XML INDEX [XMLPROPERTY_Person_Demographics]
95 ON [Person].[Person] ([Demographics])99 ON [Person].[Person] ([Demographics])
96 USING XML INDEX [PXML_Person_Demographics]100 USING XML INDEX [PXML_Person_Demographics]
97 FOR PROPERTY101 FOR PROPERTY
98GO102GO
99CREATE XML INDEX [XMLVALUE_Person_Demographics]103CREATE XML INDEX [XMLVALUE_Person_Demographics]
100 ON [Person].[Person] ([Demographics])104 ON [Person].[Person] ([Demographics])
101 USING XML INDEX [PXML_Person_Demographics]105 USING XML INDEX [PXML_Person_Demographics]
102 FOR VALUE106 FOR VALUE
103GO107GO
104ALTER TABLE [Person].[Person] SET (LOCK_ESCALATION = TABLE)108ALTER TABLE [Person].[Person] SET (LOCK_ESCALATION = TABLE)
105GO109GO
106 110 

Copyright © 2013 ReadyRoll