Another Incomparable Columns Message
There are quite a few text columns in there. Text datatypes can't be
compared in SQL Data Compare yet.
Notice, I said 'Yet' :-)
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
"Mark Vermeulen" <[email protected]> wrote in message
> 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
> message. I have scripted one of the tables and included the information
> 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]
> CREATE CLUSTERED INDEX [RsDecisionLogicIDX] ON
> [dbo].[RsDecisionLogic]([ServiceWrapperName], [Version],
> WITH FILLFACTOR = 90 ON [PRIMARY]
> ALTER TABLE [dbo].[RsDecisionLogic] WITH NOCHECK ADD
> CONSTRAINT [PK_RsDecisionLogic] PRIMARY KEY NONCLUSTERED
> ) WITH FILLFACTOR = 90 ON [PRIMARY]
> Can you help me to understand what it is I need to be looking for to
> this type of message here and when this situation comes up again?
> Thank you,
> Mark Vermeulen
> Fiserv CBS USA