Database Schema to represent directory structure

[Fadi Yoosuf]

Hi I am planning to implement a custom version control system. Is there anyway to represent physical directory structure in database? Or should I represent them using 'tree' data structure? If using tree data structure, how can I save the contents of tree to an external file?? thanks fadi

[Bassam Saoud]

which version of SQL are you using? If SQL Server 2008, you may want to look at the FileStream Datatype[^] I guess you can create a self referencing table [ heirarchical ] and either use the datatype above or file path and have some code to export it out. I dont know exactly what you want to do but it seems dangerous:)

[Mycroft Holmes]

Along with the filestream storage you can use the hierarchicyid you define your tree structure but you are going to have a coordination problem between the physical structure and the hierarchy in the table. The filestream will not allow you to move the files via explorer so that would be one benefit.

Never underestimate the power of human stupidity RAH