• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

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?
0
HLRosenberger
Asked:
HLRosenberger
  • 5
  • 5
1 Solution
 
Anthony PerkinsCommented:
Not that I know of.  Could you give us a hint as to what you mean?
0
 
HLRosenbergerAuthor Commented:
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.
0
 
Anthony PerkinsCommented:
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.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
HLRosenbergerAuthor Commented:
I have already contacted their support and emailed them the error message.
0
 
Anthony PerkinsCommented:
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.
0
 
HLRosenbergerAuthor Commented:
Version:  10.2.0.777
0
 
Anthony PerkinsCommented:
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?
0
 
HLRosenbergerAuthor Commented:
The one 2012 DB has a level of 100, and the 2008 has a level of 80.  Is this an issue?
0
 
Anthony PerkinsCommented:
Yes. In order to compare tables with a date data type they both need to have at least 100.  I would temporarily set the SQL Server 2008 DB to 100, just to prove me wrong and then set it back.

Incidentally. the default compatibility for SQL Server 2012 is 110 and for 2008 it is 100.  It sounds like the 2012 DB is set to "SQL Server 2008" Compatibility and the 2008 DB is set to "SQL Server 2000" Compatibility.
0
 
HLRosenbergerAuthor Commented:
acperkins:

Your assessment is correct.   Thanks for the help!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now