Hi Thies,
Data Compare evaluates columns for comparison by checking the name, and
like everything Data Compare does, it uses a case-sensitive comparison!
Can you verify that the EnableViewFrame and EnableCalculatedBy columns
are named exactly the same (case-sensitively) in both databases? I'm certain
that that's the reason why they aren't being compared.
Regards,
Brian Donahue
Red Gate Technical Support
"Thies Schrader" <
tsc@tandberg.no> wrote in message
news:
76tEmbZOEHA.1224@server53...
> (Please CC responses to me by email, as I do not follow this news group,
> thank you)
>
> I am now evaluating the SQL Data Compare product - I am very happy with
it.
>
> One problem I am having is with some fields at the end of tables - not
being
> compared.
>
> Running SQL Server 7 SP3, I have the following table defined:
>
> CREATE TABLE [dbo].[NET_Statistics_Chart] ([Id] [int] NOT NULL , [Heading]
> [varchar] (50) NULL , [XAxisName] [varchar] (50) NULL , [YAxisName]
> [varchar] (50) NULL ,[AxisFormatId] [int] NOT NULL , [Vertical] [bit] NOT
> NULL , [LinkPageId] [int] NOT NULL , [PageId] [int] NOT NULL ,
> [EnableViewFrame] [bit] NOT NULL , [EnableCalculatedBy] [bit] NOT NULL )
ON
> [PRIMARY]
> GO
>
> ALTER TABLE [dbo].[NET_Statistics_Chart] WITH NOCHECK ADD CONSTRAINT
> [PK_NET_Statistics_Chart] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY]
> GO
>
> My problem is that after data-comparing an empty table to a table with
many
> rows, I am getting updates but without the EnableViewFrame and
> EnableCalculatedBy columns. E.g. SQL Data Compare Script output is:
> INSERT INTO [dbo].[NET_Statistics_Chart] ([Id], [Heading], [XAxisName],
> [YAxisName], [AxisFormatId], [Vertical], [LinkPageId], [PageId]) VALUES
(2,
> 'Call Detail Record', 'Time', NULL, 1, 0, -1, 2)
>
> (Notice that the [Vertial] bit field does in fact get compared, but the
two
> last bit fields are not).
>
> Changing the bit field to be an int or renaming the
> EnableViewFrame/EnableCalculatedBy columns does not help.
>
> Can anyone understand what the problem is?
>
> - Thies Schrader
>
>
I am having the same problem and I have verified that the fields are named the same in both tables, incouding case sensitivity.
Data Compare evaluates columns for comparison by checking the name, and
like everything Data Compare does, it uses a case-sensitive comparison!
Can you verify that the EnableViewFrame and EnableCalculatedBy columns
are named exactly the same (case-sensitively) in both databases? I'm certain
that that's the reason why they aren't being compared.
Regards,
Brian Donahue
Red Gate Technical Support
"Thies Schrader" <tsc@tandberg.no> wrote in message
news:76tEmbZOEHA.1224@server53...
> (Please CC responses to me by email, as I do not follow this news group,
> thank you)
>
> I am now evaluating the SQL Data Compare product - I am very happy with
it.
>
> One problem I am having is with some fields at the end of tables - not
being
> compared.
>
> Running SQL Server 7 SP3, I have the following table defined:
>
> CREATE TABLE [dbo].[NET_Statistics_Chart] ([Id] [int] NOT NULL , [Heading]
> [varchar] (50) NULL , [XAxisName] [varchar] (50) NULL , [YAxisName]
> [varchar] (50) NULL ,[AxisFormatId] [int] NOT NULL , [Vertical] [bit] NOT
> NULL , [LinkPageId] [int] NOT NULL , [PageId] [int] NOT NULL ,
> [EnableViewFrame] [bit] NOT NULL , [EnableCalculatedBy] [bit] NOT NULL )
ON
> [PRIMARY]
> GO
>
> ALTER TABLE [dbo].[NET_Statistics_Chart] WITH NOCHECK ADD CONSTRAINT
> [PK_NET_Statistics_Chart] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY]
> GO
>
> My problem is that after data-comparing an empty table to a table with
many
> rows, I am getting updates but without the EnableViewFrame and
> EnableCalculatedBy columns. E.g. SQL Data Compare Script output is:
> INSERT INTO [dbo].[NET_Statistics_Chart] ([Id], [Heading], [XAxisName],
> [YAxisName], [AxisFormatId], [Vertical], [LinkPageId], [PageId]) VALUES
(2,
> 'Call Detail Record', 'Time', NULL, 1, 0, -1, 2)
>
> (Notice that the [Vertial] bit field does in fact get compared, but the
two
> last bit fields are not).
>
> Changing the bit field to be an int or renaming the
> EnableViewFrame/EnableCalculatedBy columns does not help.
>
> Can anyone understand what the problem is?
>
> - Thies Schrader
>
>