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

Type date not supported in the target database

I am trying out SQL Compare, comparing 2 databases on the same 2008 SQL server.

I am getting this error for all my date type columns. I know date types are new in SQL Server 2008, but I don't know why I'm getting this.

Error:
The type Date on object (MyDateColumn) is not supported in the target database
jeff.stock
0

Comments

2 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    I suspect that the target database has the compatibility mode set to SQL 2005 or below. If this is the case, then SQL Server will reject the data type.

    Let me know if that fixes the problem or not.
    Chris Auckland
    0
  • jeff.stock
    Yep that was it
    jeff.stock
    0

Add comment

Please sign in to leave a comment.