Link to home
Start Free TrialLog in
Avatar of HLRosenberger
HLRosenbergerFlag for United States of America

asked on

Date data type - SQL Server 2008 verses 2012

Does anyone know, if there some subtle difference between a Date data type on SQL Server 2008 verses 2012?
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Not that I know of.  Could you give us a hint as to what you mean?
Avatar of HLRosenberger

ASKER

I'm using a product called "SQL Compare" by RedGate.   When comparing two databases - one that's 2008 and and that's 2012 is running in 2008 emulation mode - the "SQL Compare" gives me a warning message that the Date datatype is not supported in the 2008 database.  makes no sense.
Which version of SQL Compare?  Have you checked their forums/support.  Failing that please post the exact error message here.  I can forward it on to the Red-Gate developers.
I have already contacted their support and emailed them the error message.
Excellent.Please post the version for SQL Compare you are using (For example I am using 10.2.0.1337).  Also, post the outcome from your support call so that we can all benefit from the knowledge.
Version:  10.2.0.777
And you are sure that if you do the following on both servers:
SELECT compatibility_level
FROM sys.databases d
WHERE name = 'YourDatabase'

The result is at least 100?
The one 2012 DB has a level of 100, and the 2008 has a level of 80.  Is this an issue?
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
acperkins:

Your assessment is correct.   Thanks for the help!