Erroneous warning message on Date type

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

Erroneous warning message on Date type

Postby laneg » Tue Oct 08, 2013 5:06 pm

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
 
Posts: 2
Joined: Tue Oct 08, 2013 4:54 pm

Postby Brian Donahue » Fri Oct 11, 2013 1:57 pm

You may be comparing a database that has compatibility mode on and set to a version of SQL Server lower than 2005.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby laneg » Mon Oct 14, 2013 6:22 pm

Thanks, that seems to be the issue. I appreciate the quick reply.
laneg
 
Posts: 2
Joined: Tue Oct 08, 2013 4:54 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests