Error while data comparie

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Error while data comparie

Postby reval_pradeep » Tue Jul 12, 2011 6:37 am

When I was comparing data between 2 database. I was getting following error

" The following error message was returned from the SQL Server:

[131] The size (6000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).

The following SQL command caused the error:

SELECT [SpecElementID], [SpecElementIDLbDependent], [StructureId], convert(nvarchar(6000),[Formula]) COLLATE Latin1_General_BIN , [ParentStructureId]
FROM [dbo].[tbCoElementSpecRefLinkBase] WITH (NOLOCK) ORDER BY [SpecElementID], [SpecElementIDLbDependent], [StructureId] "


and same error occure while comparie text datatype. Anybody could give me a solution
reval_pradeep
 
Posts: 3
Joined: Mon Jul 11, 2011 11:27 am

Postby peter.peart » Tue Jul 12, 2011 1:39 pm

Thanks for your post. Are the schema's exactly the same that you are performing a comparison against, or do the data types differ at all?

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby reval_pradeep » Wed Jul 13, 2011 2:07 pm

thanks for your valuable reply,

The Schema was identical but collation was different between SQL_Latin1_General_CP1_CI_AS and Arabic_100_CI_AS in that 2 tables.

Pradeep
reval_pradeep
 
Posts: 3
Joined: Mon Jul 11, 2011 11:27 am

Postby peter.peart » Thu Jul 14, 2011 7:48 pm

Ok, well this is probably down to the difference in collation, however it's very difficult to say for sure without copies of your DB's as it looks to be a data specific problem around casting.

Are you able to send these across?
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron