Another Incomparable Columns Message

Brian Donahue

Hi Mark,

There are quite a few text columns in there. Text datatypes can't be
compared in SQL Data Compare yet.
Notice, I said 'Yet' :-)

Regards,

Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

+44 870 1600 037

mailto:brian.donahue@red-gate.com


"Mark Vermeulen" <mvermeulen@cfl.rr.com> wrote in message
news:DZ5Bulw7CHA.1432@server53...
> I have read the other messages regarding incomparable columns and cannot
> translate what has already been stated to my circumstance.
> I have three tables, two of which are displaying the "incomparable
columns"
> message. I have scripted one of the tables and included the information
> below
> rather than try and describe it further.
>
> CREATE TABLE [dbo].[RsDecisionLogic] (
> [RsDecisionLogicId] [int] IDENTITY (1, 1) NOT NULL ,
> [ServiceWrapperName] [varchar] (50) NULL ,
> [Version] [varchar] (10) NULL ,
> [TransactionName] [varchar] (50) NULL ,
> [StartPos] [int] NULL ,
> [Length] [int] NULL ,
> [Delimiter] [varchar] (50) NULL ,
> [Code] [varchar] (50) NULL ,
> [HostXMLTemplate] [text] NULL ,
> [HostXMLTemplateDesc] [varchar] (50) NULL ,
> [HostType] [varchar] (50) NULL ,
> [XSLT] [text] NULL
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> GO
>
> CREATE CLUSTERED INDEX [RsDecisionLogicIDX] ON
> [dbo].[RsDecisionLogic]([ServiceWrapperName], [Version],
[TransactionName])
> WITH FILLFACTOR = 90 ON [PRIMARY]
> GO
>
> ALTER TABLE [dbo].[RsDecisionLogic] WITH NOCHECK ADD
> CONSTRAINT [PK_RsDecisionLogic] PRIMARY KEY NONCLUSTERED
> (
> [RsDecisionLogicId]
> ) WITH FILLFACTOR = 90 ON [PRIMARY]
> GO
>
> Can you help me to understand what it is I need to be looking for to
resolve
> this type of message here and when this situation comes up again?
>
> Thank you,
>
> Mark Vermeulen
> Fiserv CBS USA
>
>