Red Gate forums :: View topic - Erroneous warning message on Date type
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Erroneous warning message on Date type

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
laneg



Joined: 08 Oct 2013
Posts: 2

PostPosted: Tue Oct 08, 2013 5:06 pm    Post subject: Erroneous warning message on Date type Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Oct 11, 2013 1:57 pm    Post subject: Reply with quote

You may be comparing a database that has compatibility mode on and set to a version of SQL Server lower than 2005.
Back to top
View user's profile Send private message
laneg



Joined: 08 Oct 2013
Posts: 2

PostPosted: Mon Oct 14, 2013 6:22 pm    Post subject: Reply with quote

Thanks, that seems to be the issue. I appreciate the quick reply.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group