HLRosenberger
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?
Not that I know of. Could you give us a hint as to what you mean?
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.
ASKER
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.
ASKER
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?
SELECT compatibility_level
FROM sys.databases d
WHERE name = 'YourDatabase'
The result is at least 100?
ASKER
The one 2012 DB has a level of 100, and the 2008 has a level of 80. Is this an issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
acperkins:
Your assessment is correct. Thanks for the help!
Your assessment is correct. Thanks for the help!