Type date not supported in the target database

jeff.stock

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

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.

jeff.stock

Yep that was it