Our problem is this,
we have a relational database to store
objects in tables. As any relational database could, several
of these tables have multiple foreign keys pointing to other tables (all pretty normal stuff)
We've been trying to identify a solution to allow export
of this relational data, ideally, only 1
of the
objects in the model, to some sort
of file (xml, text, ??). So it wouldn't be simple enough to just export 1 table as data stored in other tables would contribute to the complete model
of the object. Something like the following picture:
Toward this, i've written a routine to export the structure by following the foreign key paths which exports something similar to the following.
<Tables>
<TableA PK="1", val1, val2, val3>
<TableC PK="1", FK_A="1", Val1, val2, val3>
<TableC PK="2", FK_A="1", val1, val2, val3>
<TableB PK="1", FK_A="1", FK_C="1", val1, val2, val3>
<TableB PK="2", FK_A="1", FK_C="2", val1, val2, val3>
<TableD PK="1", FK_B="1", FK_C="1", val1>
<TableD PK="2", FK_B="2", FK_C="1", val1>
</Tables>
However, given this structure, it cannot be placed into a heirarchial format (ie D2 is a child
of C1 and B2; and B2 is a child
of C2)
Which in turn, makes my life very difficult when trying to identify a methodology to reimport (and reKey) these
objects.
Has anybody done anything like this? how do you do it? are there tools or documentation on how this is best accomplished?
Thanks for your help.
