Error- The version of SQL Server in use does not support datatype 'datetime2'

Question

Hi,

I am trying to migrate TFS 2008 to TFS 2010 using the TFS integration tool and I get the following error:

[6/5/2012 12:53:34 PM] TfsIntegrationService.exe Warning: 0 : : An error occurred while updating the entries. See the InnerException for details. 
[6/5/2012 12:53:34 PM] TfsIntegrationService.exe Information: 0 : : System.Data.UpdateException: An error occurred while updating the entries. See the InnerException for details. ---> System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2'. 
[6/5/2012 12:53:34 PM] at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 
[6/5/2012 12:53:34 PM] at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior

Please suggest what can be done.

Thanks

Ram Subhash

Answer 1

Hi Ram, 

Thanks for your post.

If your TFS 2008 use the SQL Server 2005 and your TFS 2010 use the SQL Server 2008, so I think this issue is relate to the SQL 2008 and 2005 compatibility. 

Please refer to this article: http://altfo.wordpress.com/2010/06/11/this-version-of-sql-server-in-use-does-not-support-datatype-datetime2/.       

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Ram,

Has this issue been resolved?  

If misunderstood anything, please describe your question in more detail and we will be able to provide the better responses.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi all,

I too have the same problem. I don't really know what edmx files are to be changed, but I did check all on my computer. They all have 2005 already defined.

I am trying to move TFS source data from TFS 2008 to a TFS 2010 instance.

Regards

David DeSouza