Options
Type date not supported in the target database
jeff.stock
Posts: 3
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
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
Comments
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.