How can we help you today? How can we help you today?

Erroneous warning message on Date type

I am doing a comparison between two databases that are on the same instance of SQL Server 12. Here's a link to a screenshot of the comparision:

http://screencast.com/t/ngeLQi1sO

From the screenshot, you can see that both the source and target databases have the same columns.

However, when I generate the deployment script, I get an "Unsupported datatype" error:

Severity: High
Object: PurchaseOrder
Title: The type Date on object [dbo].[PurchaseOrder].[PODate] is not supported in the target database version.

This clearly is an erroneous message, but is there something I need to do to configure SQL Compare to prevent it from being generated?
laneg
0

Comments

2 comments

  • Brian Donahue
    You may be comparing a database that has compatibility mode on and set to a version of SQL Server lower than 2005.
    Brian Donahue
    0
  • laneg
    Thanks, that seems to be the issue. I appreciate the quick reply.
    laneg
    0

Add comment

Please sign in to leave a comment.