how do I visually see relationships in a DB?

[korsuas]

I would like to have a software to see/print relationships just like Access or MSSQL... does anyone know smtg like that?

Thank you,
Adian Korsuas

 

[GuptaSteve]

Please be more specific - what DB are you running ?

 

[GuptaSteve]

One option is to use the Gupta tool TOM - Team Object Manager. You must have Imported your database schema by using the import wizard under 'Import Data Model' menu item and then 'Database' menu item under the 'Data Models' section , which exists under the 'Project' you must create for this excersise. Once the schema has been imported from whatever source, you have many options to view and/or compare it in a pictorial format. The options you choose when importing the schema, dictate how they are displayed afterwards i.e. use the 'Referential Integrity' option if SqlBase. You should be using TOM as a repository for your Gupta code already ( hope you dont use MS Visual Source Safe ) , in which case you can see 'Data Models' as one of the Project's sections, and take it from there.

 

[GuptaSteve]

One option is to use the Gupta tool TOM - Team Object Manager. You must have Imported your database schema by using the import wizard under 'Import Data Model' menu item and then 'Database' menu item under the 'Data Models' section , which exists under the 'Project' you must create for this excersise. Once the schema has been imported from whatever source, you have many options to view and/or compare it in a pictorial format. The options you choose when importing the schema, dictate how they are displayed afterwards i.e. use the 'Referential Integrity' option if SqlBase. You should be using TOM as a repository for your Gupta code already ( hope you dont use MS Visual Source Safe ) , in which case you can see 'Data Models' as one of the Project's sections, and take it from there.