Datatype not supported in the target database version

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Datatype not supported in the target database version

Postby mark_anderson_us » Mon Sep 16, 2013 10:15 pm

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
mark_anderson_us
 
Posts: 23
Joined: Sat Apr 28, 2012 8:27 pm

Postby Brian Donahue » Thu Sep 19, 2013 11:36 am

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?
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby mark_anderson_us » Thu Sep 19, 2013 4:09 pm

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
mark_anderson_us
 
Posts: 23
Joined: Sat Apr 28, 2012 8:27 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests