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 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
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.