Skip to main content
SUBMITTED

Support the SQL Server hierarchyid field type

Related products:TimeXtender Data Integration
  • August 2, 2023
  • 0 replies
  • 18 views

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8

Many data platforms require hierarchical data. There are quite complex ways of dealing with this kind of data that often require recursive CTEs with usually bad performance..But SQL Server has had a specific data type for this since SQL 2008. It would be good if TimeXtender supported the hierarchyid field so we could use this.

See: https://learn.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-ver16