HI There,
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.
Thanks in advance.
Cheers,
Vidhya Raocould you please script the table, i.e. show us the CREATE TABLE statement|||Hi There,
Please can you tell me in detail what u require.
Cheers,
Vidhya|||why don't you start with the CREATE TABLE statement
:)|||Hello,
it is not a data design, it is refactoring a database design which has a hierarchial relationship.
Cheers,
Vidhya|||okay, then
you can start by explaining what you mean by "refactoring"
and i will ask you for the 3rd time, would you please show us your CREATE TABLE statement so that we can see what kind of a hierarchy you have|||Hello,
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.
Please provide me your mail id if possible!!1
Cheers,
Vidhya|||sorry, i don't provide private support for free!!!111|||hi yeh,
Im actually looking for a good mentor to help out i this project.
Im very new to design and started learning now. If you are really an experieced designer please let me know.
if you need contact let me know. Im planning to pay for the service.
Cheers,
Vidhya|||Did someone fib on their resume, and now they have to pay the piper ?
Not a fun situation to be in.:S|||you mentioned medical data and hierarchial tree structure...
are you converting a mumps hierarchial database to a SQL database ?|||are you converting a mumps hierarchial database to a SQL database ?
* Ouch *
