DDL Import - SQL server

Prakash_Mavuduru

I am trying to reverse engineer an existing SQL server database into Provision models.

 

The Database uses RI (foreign keys).

 

The tables and attributes import correctly however none of the relationships do, so I end up with a bunch of disconnected business classes.

 

Would anyone know if it is feasible to reverse engineer the relationships as well ? What are the steps I need to take ?

 

Any assistance shall be very much appreciated.

 

Cheers,

Prakash

Jim_Stuart

Hi Prakash,  If you could unload these missing relationships from your SQL to excel, then I think we could use the translator to build and load the relationships.  Jim.

Prakash_Mavuduru

Thanks Jim.

 

Is the inability to detect relationships between table a known limitation of the DDL reverse engineering capability ?

 

Cheers,

Prakash