Red Gate forums :: View topic - Datatype not supported in the target database version
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Datatype not supported in the target database version

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mark_anderson_us



Joined: 28 Apr 2012
Posts: 23

PostPosted: Mon Sep 16, 2013 10:15 pm    Post subject: Datatype not supported in the target database version Reply with quote

Severity: High
Object: SG_WIP_BI
Title: The datatype of the parameter @EndDate of stored procedure [dbo].[SG_WIP_BI] is not supported in the target database version.

Hi guys

Any idea why I'm getting above, when deploying schema changes. The source and target are both on SQL 10.50.2550. When first installed the target was on an older release, but has since been brought up to same level. The variable is a Date type

Thanks

Mark
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Thu Sep 19, 2013 11:36 am    Post subject: Reply with quote

Hi Mark,

It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself?
Back to top
View user's profile Send private message
mark_anderson_us



Joined: 28 Apr 2012
Posts: 23

PostPosted: Thu Sep 19, 2013 4:09 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
Hi Mark,

It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself?


Never thought to check compatibility level. Will take a look next time I connect
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