[Data Extractor] Cannot add Entities on SQL Server 2008 R2

[Data Extractor] Cannot add Entities on SQL Server 2008 R2

  
Forge Component
(9)
Published on 2017-04-20 by Carlos Sousa
9 votes
Published on 2017-04-20 by Carlos Sousa

Hello,

CONCAT is only supported from SQL Server 2012 onward. 

On SQL Server 2008 R2, when trying to search for entities to add to the snaphot, we have the following error:

'CONCAT' is not a recognized built-in function name.


I can use   +   to unblock me, but for this component to support both Oracle and SQL Server, you should solve this. Or add a disclaimer about that it only works for SQL Server 2012.