Im now working on a assignment where i have hierarchial tree structure arrangement for representing an health care. This is supported by SQL DB 2005.One of the node in the tree is dissolved and all it functionality have to ported to the other tree node which share the similar structure.
Problem in porting is complex due to the following things
1. There are capabilities and permission associated with the each node.
2.each node has a unique identifier across the three (note: though this seems to be of no problem it might become issue when search occurs for eg. a->b->c search now becomes a->b->x->n ->?).
3.Already there are messages left in the DB. Please can anyone help me how can i initiate this migration. Im very new to the design and im just started "ABCD" of it.
IF you are available online please do let me know i can send you the DB diagrams. There are many tables and they exhibit strong relationship.
DB structure is not hierarchial but way the directory which im trying to port is the hierarchical.
you mentioned medical data and hierarchial tree structure...
are you converting a mumps hierarchial database to a SQL database ?
Providing Technology services to non profit orgs, Homeless Shelters, Food Pantries, Clean And Sober Houses and more. To date we have given away over 900 free computers !
caeli enarrant gloriam Dei !