Red Gate forums :: View topic - "Unsupported column type - Empty" comparing scripts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

"Unsupported column type - Empty" comparing scripts

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
JackAce



Joined: 08 Jul 2011
Posts: 37

PostPosted: Mon Aug 01, 2011 10:16 pm    Post subject: "Unsupported column type - Empty" comparing scripts Reply with quote

When comparing two SVN tags of the same database repository script folders, I get the error

Unsupported column type - Empty

I get this when just comparing a single table that exists in both script folders. I get the same error no matter what tables I compare. The only time I didn't get the error was when I compared two tables that had no data in it.

Is this a known issue or is there a work around? Is it not possible to compare the data contents of two tables that are populated by the /Data/dbo.MyTable_Data.sql scripts?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Aug 02, 2011 1:51 pm    Post subject: Reply with quote

Thanks for your post.

This issue is new to me, so I can't tell you exactly why it's happening.

Can you tell me:

1) Which version of SQL Data compare 9 are you using? (help> About)
2) Does this happen when you use the GUI, or is it just commandline or API?
3) Were the data scripts created by SQL Data Compare?
4) Are you checking out just the data scripts from SVN and comparing them, or are you also checking out the schema statements in the /tables folder too?
5) Could you post the DDL for the dbo.MyTable?

Thanks,
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
JackAce



Joined: 08 Jul 2011
Posts: 37

PostPosted: Tue Aug 02, 2011 8:24 pm    Post subject: Re: Reply with quote

So I figured out what was causing the problem.

We have a UserDefinedDataType called dbo.KeyType which is just a wrapper for a BIGINT datatype. If I manually edit the datatype and change it to BIGINT in the table generation script, the error goes away and there doesn't seem to be any problems. We will eventually change all the KeyType fields to be BIGINT, so this issue will eventually go away for us.

In any case, here are the answers to your questions:

Chris Auckland wrote:

1) Which version of SQL Data compare 9 are you using? (help> About)
2) Does this happen when you use the GUI, or is it just commandline or API?
3) Were the data scripts created by SQL Data Compare?
4) Are you checking out just the data scripts from SVN and comparing them, or are you also checking out the schema statements in the /tables folder too?
5) Could you post the DDL for the dbo.MyTable?


1) I am using Red Gate SQL Data Compare v9.0.0.117
2) I get the Unsupported column type - empty error when using the GUI.
3) The scripts were generated using SQL Source Control, not SQL Data Compare
4) The script repository has both a Data and a Tables folder, both generated by SQL Source Control
5) Here's the table generation script (with some names obfuscated):

Code:

CREATE TABLE [dbo].[ActivityFeedSource]
(
[ID] [dbo].[KeyType] NOT NULL IDENTITY(1, 1),
[CodeFile] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MethodName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayToCustomer] [bit] NOT NULL CONSTRAINT [DF_1] DEFAULT ((1)),
[OriginatingCustomerText] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OriginatingCustomerPublicText] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SharedCustomerPublicText] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF_ActivityFeedSource_IsActive] DEFAULT ((1)),
[Display] [bit] NOT NULL CONSTRAINT [DF_ActivityFeedSource_Display] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ActivityFeedSource] ADD CONSTRAINT [PK_ActivityFeedSource] PRIMARY KEY CLUSTERED  ([ID]) WITH (STATISTICS_NORECOMPUTE=ON) ON [PRIMARY]
GO

Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group